/usr/bin/postmaster: PostmasterMain: initial environ dump:
-----------------------------------------
	PWD=/var/lib/pgsql
	LC_MESSAGES=en_US
	HOSTNAME=wsvan644.sierrasys.com
	LESSKEY=/etc/.less
	LESSOPEN=|/usr/bin/lesspipe.sh %s
	LANGUAGE=en_US:en
	KDEDIR=/usr
	LESS=-MM
	USER=postgres
	LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.tar=01;31:*.tgz=01;31:*.tbz2=01;31:*.arc=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lha=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:*.tiff=01;35:
	LC_TIME=en_US
	MACHTYPE=i586-mandrake-linux-gnu
	LC_ALL=C
	MAIL=/var/spool/mail/postgres
	INPUTRC=/etc/inputrc
	CVS_RSH=/usr/bin/ssh
	LANG=en
	JAVA_HOME=/usr/local/jdk1.2.2
	LC_NUMERIC=en_US
	LOGNAME=postgres
	SHLVL=2
	LC_CTYPE=en_US
	SHELL=/bin/sh
	HOSTTYPE=i586
	CVSROOT=lblain@exhibitx:/home/cvsroot/HBT
	OSTYPE=linux-gnu
	HISTSIZE=1000
	TERM=xterm-color
	HOME=/var/lib/pgsql
	PGDATA=/var/lib/pgsql/data
	PATH=/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games
	SECURE_LEVEL=3
	LC_MONETARY=en_US
	RPM_INSTALL_LANG=en
	LC_COLLATE=en_US
	_=/usr/bin/postmaster
-----------------------------------------
invoking IpcMemoryCreate(size=9232384)
FindExec: found "/usr/bin/postmaster" using argv[0]
DEBUG:  database system was shut down at 2001-05-23 15:02:01 
DEBUG:  CheckPoint record at (0, 566679936)
DEBUG:  Redo record at (0, 566679936); Undo record at (0, 0); Shutdown TRUE
DEBUG:  NextTransactionId: 25765; NextOid: 1347203
DEBUG:  database system is in production state
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
/usr/bin/postmaster: reaping dead processes...
/usr/bin/postmaster: CleanupProc: pid 5296 exited with status 0
/usr/bin/postmaster: ServerLoop:		handling reading 5
/usr/bin/postmaster: ServerLoop:		handling reading 5
/usr/bin/postmaster: ServerLoop:		handling writing 5
/usr/bin/postmaster: BackendStartup: pid 5312 user postgres db hbtsynctest2 socket 5
/usr/bin/postmaster child[5312]: starting with (postgres -d3 -v131072 -p hbtsynctest2 )
FindExec: found "/usr/bin/postgres" using argv[0]
DEBUG:  connection: host=[local] user=postgres database=hbtsynctest2
DEBUG:  InitPostgres
DEBUG:  StartTransactionCommand
DEBUG:  query: select getdatabaseencoding()
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable <> :jointree { FROMEXPR :fromlist <> :quals <>} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 19 :restypmod -1 :resname getdatabaseencoding :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { EXPR :typeOid 19  :opType func :oper { FUNC :funcid 1039 :functype 19 } :args <>}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: SELECT usesuper FROM pg_user WHERE usename = 'postgres'
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname pg_user :relid 17291  :subquery <> :alias <> :eref { ATTR :relname pg_user :attrs ( "usename"   "usesysid"   "usecreatedb"   "usetrace"   "usesuper"   "usecatupd"   "passwd"   "valuntil" )} :inh true :inFromCl true :checkForRead true :checkForWrite false :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType op :oper { OPER :opno 93 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 19 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 19 :constlen 32 :constbyval false :constisnull false :constvalue  32 [ 112 111 115 116 103 114 101 115 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ] })}} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 16 :restypmod -1 :resname usesuper :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 5 :vartype 16 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 5}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: update cvg_rptd set rptg_session_id = NULL, cvg_rptd_sts_cd = 0,
cvg_rptd_except_sts_cd = 0, cvg_rptd_except_desc = NULL, mdfy_dt = now()
where emp_grp_id = 'DB1F2BCA-9272-D411-B712-0008C78CB1FE' and
ben_plan_id = '51E79587-D136-D411-B5F4-0050DA5FD075' and grp_rate_id =
'F7E6C60D-1979-11D5-AE7D-001083FD6A84' and rate_step_id =
'CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3' and rptg_seq_id =
'3743CB52-2D46-11D5-8A09-00508B0E83B6' and rptg_seq_id =
'3743CB52-2D46-11D5-8A09-00508B0E83B6' and rptg_prd_end_dt =
'2001-04-30';
DEBUG:  parse tree: { QUERY :command 2  :utility <> :resultRelation 1 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749  :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rptg_prd_end_dt"   "rptg_seq_id"   "rptg_session_id"   "cvg_rptd_sts_cd"   "cvg_rptd_except_sts_cd"   "cvg_rptd_except_desc"   "mdfy_dt" )} :inh true :inFromCl false :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ -54 43 31 -37 114 -110 17 -44 -73 18 0 8 -57 -116 -79 -2 ] })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ -121 -107 -25 81 54 -47 17 -44 -75 -12 0 80 -38 95 -48 117 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ 13 -58 -26 -9 121 25 -43 17 -82 125 0 16 -125 -3 106 -124 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ -57 62 42 -49 -29 -32 -45 17 -87 -69 0 96 -80 104 35 -61 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ 82 -53 67 55 70 45 -43 17 -118 9 0 80 -117 14 -125 -74 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ 82 -53 67 55 70 45 -43 17 -118 9 0 80 -117 14 -125 -74 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 5} { CONST :consttype 1082 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ -27 1 0 0 ] })})}} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 7 :restype 1288591 :restypmod -1 :resname rptg_session_id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull true :constvalue <>}} { TARGETENTRY :resdom { RESDOM :resno 8 :restype 21 :restypmod -1 :resname cvg_rptd_sts_cd :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue  2 [ 0 0 0 0 ] }} { TARGETENTRY :resdom { RESDOM :resno 9 :restype 21 :restypmod -1 :resname cvg_rptd_except_sts_cd :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue  2 [ 0 0 0 0 ] }} { TARGETENTRY :resdom { RESDOM :resno 10 :restype 1043 :restypmod 154 :resname cvg_rptd_except_desc :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { EXPR :typeOid 1043  :opType func :oper { FUNC :funcid 669 :functype 1043 } :args ({ CONST :consttype 1043 :constlen -1 :constbyval false :constisnull true :constvalue <>} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ -102 0 0 0 ] })}} { TARGETENTRY :resdom { RESDOM :resno 11 :restype 1184 :restypmod -1 :resname mdfy_dt :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { EXPR :typeOid 1184  :opType func :oper { FUNC :funcid 1299 :functype 1184 } :args <>}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  ProcessQuery
DEBUG:  query: SELECT oid FROM ONLY "grp_rate_step" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 FOR UPDATE OF "grp_rate_step"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname grp_rate_step :relid 1288970  :subquery <> :alias <> :eref { ATTR :relname grp_rate_step :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rate_fmt_flat_amt"   "rate_fmt_salary_pct"   "rate_fmt_dollars_per_ten_cvg"   "rate_fmt_dollars_per_thou_cvg"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "rptg_seq" WHERE "rptg_seq_id" = $1 FOR UPDATE OF "rptg_seq"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname rptg_seq :relid 1289176  :subquery <> :alias <> :eref { ATTR :relname rptg_seq :attrs ( "rptg_seq_id"   "rptg_seq_typ_id"   "rptg_seq_start_dt"   "rptg_seq_semimo_2nd_start_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "grp_rate_step" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 FOR UPDATE OF "grp_rate_step"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname grp_rate_step :relid 1288970  :subquery <> :alias <> :eref { ATTR :relname grp_rate_step :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rate_fmt_flat_amt"   "rate_fmt_salary_pct"   "rate_fmt_dollars_per_ten_cvg"   "rate_fmt_dollars_per_thou_cvg"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "rptg_seq" WHERE "rptg_seq_id" = $1 FOR UPDATE OF "rptg_seq"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname rptg_seq :relid 1289176  :subquery <> :alias <> :eref { ATTR :relname rptg_seq :attrs ( "rptg_seq_id"   "rptg_seq_typ_id"   "rptg_seq_start_dt"   "rptg_seq_semimo_2nd_start_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "grp_rate_step" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 FOR UPDATE OF "grp_rate_step"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname grp_rate_step :relid 1288970  :subquery <> :alias <> :eref { ATTR :relname grp_rate_step :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rate_fmt_flat_amt"   "rate_fmt_salary_pct"   "rate_fmt_dollars_per_ten_cvg"   "rate_fmt_dollars_per_thou_cvg"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "rptg_seq" WHERE "rptg_seq_id" = $1 FOR UPDATE OF "rptg_seq"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname rptg_seq :relid 1289176  :subquery <> :alias <> :eref { ATTR :relname rptg_seq :attrs ( "rptg_seq_id"   "rptg_seq_typ_id"   "rptg_seq_start_dt"   "rptg_seq_semimo_2nd_start_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "grp_rate_step" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 FOR UPDATE OF "grp_rate_step"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname grp_rate_step :relid 1288970  :subquery <> :alias <> :eref { ATTR :relname grp_rate_step :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rate_fmt_flat_amt"   "rate_fmt_salary_pct"   "rate_fmt_dollars_per_ten_cvg"   "rate_fmt_dollars_per_thou_cvg"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "rptg_seq" WHERE "rptg_seq_id" = $1 FOR UPDATE OF "rptg_seq"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname rptg_seq :relid 1289176  :subquery <> :alias <> :eref { ATTR :relname rptg_seq :attrs ( "rptg_seq_id"   "rptg_seq_typ_id"   "rptg_seq_start_dt"   "rptg_seq_semimo_2nd_start_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "grp_rate_step" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 FOR UPDATE OF "grp_rate_step"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname grp_rate_step :relid 1288970  :subquery <> :alias <> :eref { ATTR :relname grp_rate_step :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rate_fmt_flat_amt"   "rate_fmt_salary_pct"   "rate_fmt_dollars_per_ten_cvg"   "rate_fmt_dollars_per_thou_cvg"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "rptg_seq" WHERE "rptg_seq_id" = $1 FOR UPDATE OF "rptg_seq"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname rptg_seq :relid 1289176  :subquery <> :alias <> :eref { ATTR :relname rptg_seq :attrs ( "rptg_seq_id"   "rptg_seq_typ_id"   "rptg_seq_start_dt"   "rptg_seq_semimo_2nd_start_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "grp_rate_step" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 FOR UPDATE OF "grp_rate_step"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname grp_rate_step :relid 1288970  :subquery <> :alias <> :eref { ATTR :relname grp_rate_step :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rate_fmt_flat_amt"   "rate_fmt_salary_pct"   "rate_fmt_dollars_per_ten_cvg"   "rate_fmt_dollars_per_thou_cvg"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "rptg_seq" WHERE "rptg_seq_id" = $1 FOR UPDATE OF "rptg_seq"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname rptg_seq :relid 1289176  :subquery <> :alias <> :eref { ATTR :relname rptg_seq :attrs ( "rptg_seq_id"   "rptg_seq_typ_id"   "rptg_seq_start_dt"   "rptg_seq_semimo_2nd_start_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "grp_rate_step" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 FOR UPDATE OF "grp_rate_step"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname grp_rate_step :relid 1288970  :subquery <> :alias <> :eref { ATTR :relname grp_rate_step :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rate_fmt_flat_amt"   "rate_fmt_salary_pct"   "rate_fmt_dollars_per_ten_cvg"   "rate_fmt_dollars_per_thou_cvg"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "rptg_seq" WHERE "rptg_seq_id" = $1 FOR UPDATE OF "rptg_seq"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname rptg_seq :relid 1289176  :subquery <> :alias <> :eref { ATTR :relname rptg_seq :attrs ( "rptg_seq_id"   "rptg_seq_typ_id"   "rptg_seq_start_dt"   "rptg_seq_semimo_2nd_start_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "grp_rate_step" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 FOR UPDATE OF "grp_rate_step"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname grp_rate_step :relid 1288970  :subquery <> :alias <> :eref { ATTR :relname grp_rate_step :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rate_fmt_flat_amt"   "rate_fmt_salary_pct"   "rate_fmt_dollars_per_ten_cvg"   "rate_fmt_dollars_per_thou_cvg"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "rptg_seq" WHERE "rptg_seq_id" = $1 FOR UPDATE OF "rptg_seq"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname rptg_seq :relid 1289176  :subquery <> :alias <> :eref { ATTR :relname rptg_seq :attrs ( "rptg_seq_id"   "rptg_seq_typ_id"   "rptg_seq_start_dt"   "rptg_seq_semimo_2nd_start_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: update stepped_cvg_rptd set step_cvg_rptd_emp_count = 44,
step_cvg_rptd_cvg_amt = NULL where emp_grp_id =
'DB1F2BCA-9272-D411-B712-0008C78CB1FE' and ben_plan_id =
'51E79587-D136-D411-B5F4-0050DA5FD075' and grp_rate_id =
'F7E6C60D-1979-11D5-AE7D-001083FD6A84' and rate_step_id =
'CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3' and rptg_seq_id =
'3743CB52-2D46-11D5-8A09-00508B0E83B6' and rptg_seq_id =
'3743CB52-2D46-11D5-8A09-00508B0E83B6' and rptg_prd_end_dt =
'2001-04-30'  and cvgstep_id = '73B7259C-3A46-D511-8A0A-00508B0E83B6';
DEBUG:  parse tree: { QUERY :command 2  :utility <> :resultRelation 1 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname stepped_cvg_rptd :relid 1289245  :subquery <> :alias <> :eref { ATTR :relname stepped_cvg_rptd :attrs ( "cvgstep_id"   "emp_grp_id"   "grp_rate_id"   "rate_step_id"   "ben_plan_id"   "rptg_seq_id"   "rptg_prd_end_dt"   "step_cvg_rptd_emp_count"   "step_cvg_rptd_cvg_amt" )} :inh true :inFromCl false :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ -54 43 31 -37 114 -110 17 -44 -73 18 0 8 -57 -116 -79 -2 ] })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 5} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ -121 -107 -25 81 54 -47 17 -44 -75 -12 0 80 -38 95 -48 117 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ 13 -58 -26 -9 121 25 -43 17 -82 125 0 16 -125 -3 106 -124 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ -57 62 42 -49 -29 -32 -45 17 -87 -69 0 96 -80 104 35 -61 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ 82 -53 67 55 70 45 -43 17 -118 9 0 80 -117 14 -125 -74 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ 82 -53 67 55 70 45 -43 17 -118 9 0 80 -117 14 -125 -74 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 7 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 7} { CONST :consttype 1082 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ -27 1 0 0 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ -100 37 -73 115 70 58 17 -43 -118 10 0 80 -117 14 -125 -74 ] })})}} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 8 :restype 23 :restypmod -1 :resname step_cvg_rptd_emp_count :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 44 0 0 0 ] }} { TARGETENTRY :resdom { RESDOM :resno 9 :restype 23 :restypmod -1 :resname step_cvg_rptd_cvg_amt :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constbyval true :constisnull true :constvalue <>}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  ProcessQuery
DEBUG:  query: SELECT oid FROM ONLY "coverage_step" WHERE "ben_plan_id" = $1 AND "cvgstep_id" = $2 FOR UPDATE OF "coverage_step"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname coverage_step :relid 1288729  :subquery <> :alias <> :eref { ATTR :relname coverage_step :attrs ( "ben_plan_id"   "cvgstep_id"   "cvgstep_hal_step_no"   "cvgstep_hal_evnt_id"   "cvgstep_desc"   "cvgstep_per_emp_flat_amt"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "cvg_rptd" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 AND "rptg_seq_id" = $5 AND "rptg_prd_end_dt" = $6 FOR UPDATE OF "cvg_rptd"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749  :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rptg_prd_end_dt"   "rptg_seq_id"   "rptg_session_id"   "cvg_rptd_sts_cd"   "cvg_rptd_except_sts_cd"   "cvg_rptd_except_desc"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6} { PARAM :paramkind 12 :paramid 5 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 5} { PARAM :paramkind 12 :paramid 6 :paramname \<unnamed> :paramtype 1082 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "coverage_step" WHERE "ben_plan_id" = $1 AND "cvgstep_id" = $2 FOR UPDATE OF "coverage_step"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname coverage_step :relid 1288729  :subquery <> :alias <> :eref { ATTR :relname coverage_step :attrs ( "ben_plan_id"   "cvgstep_id"   "cvgstep_hal_step_no"   "cvgstep_hal_evnt_id"   "cvgstep_desc"   "cvgstep_per_emp_flat_amt"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "cvg_rptd" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 AND "rptg_seq_id" = $5 AND "rptg_prd_end_dt" = $6 FOR UPDATE OF "cvg_rptd"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749  :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rptg_prd_end_dt"   "rptg_seq_id"   "rptg_session_id"   "cvg_rptd_sts_cd"   "cvg_rptd_except_sts_cd"   "cvg_rptd_except_desc"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6} { PARAM :paramkind 12 :paramid 5 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 5} { PARAM :paramkind 12 :paramid 6 :paramname \<unnamed> :paramtype 1082 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "coverage_step" WHERE "ben_plan_id" = $1 AND "cvgstep_id" = $2 FOR UPDATE OF "coverage_step"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname coverage_step :relid 1288729  :subquery <> :alias <> :eref { ATTR :relname coverage_step :attrs ( "ben_plan_id"   "cvgstep_id"   "cvgstep_hal_step_no"   "cvgstep_hal_evnt_id"   "cvgstep_desc"   "cvgstep_per_emp_flat_amt"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "cvg_rptd" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 AND "rptg_seq_id" = $5 AND "rptg_prd_end_dt" = $6 FOR UPDATE OF "cvg_rptd"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749  :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rptg_prd_end_dt"   "rptg_seq_id"   "rptg_session_id"   "cvg_rptd_sts_cd"   "cvg_rptd_except_sts_cd"   "cvg_rptd_except_desc"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6} { PARAM :paramkind 12 :paramid 5 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 5} { PARAM :paramkind 12 :paramid 6 :paramname \<unnamed> :paramtype 1082 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "coverage_step" WHERE "ben_plan_id" = $1 AND "cvgstep_id" = $2 FOR UPDATE OF "coverage_step"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname coverage_step :relid 1288729  :subquery <> :alias <> :eref { ATTR :relname coverage_step :attrs ( "ben_plan_id"   "cvgstep_id"   "cvgstep_hal_step_no"   "cvgstep_hal_evnt_id"   "cvgstep_desc"   "cvgstep_per_emp_flat_amt"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "cvg_rptd" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 AND "rptg_seq_id" = $5 AND "rptg_prd_end_dt" = $6 FOR UPDATE OF "cvg_rptd"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749  :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rptg_prd_end_dt"   "rptg_seq_id"   "rptg_session_id"   "cvg_rptd_sts_cd"   "cvg_rptd_except_sts_cd"   "cvg_rptd_except_desc"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6} { PARAM :paramkind 12 :paramid 5 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 5} { PARAM :paramkind 12 :paramid 6 :paramname \<unnamed> :paramtype 1082 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "coverage_step" WHERE "ben_plan_id" = $1 AND "cvgstep_id" = $2 FOR UPDATE OF "coverage_step"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname coverage_step :relid 1288729  :subquery <> :alias <> :eref { ATTR :relname coverage_step :attrs ( "ben_plan_id"   "cvgstep_id"   "cvgstep_hal_step_no"   "cvgstep_hal_evnt_id"   "cvgstep_desc"   "cvgstep_per_emp_flat_amt"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "cvg_rptd" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 AND "rptg_seq_id" = $5 AND "rptg_prd_end_dt" = $6 FOR UPDATE OF "cvg_rptd"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749  :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rptg_prd_end_dt"   "rptg_seq_id"   "rptg_session_id"   "cvg_rptd_sts_cd"   "cvg_rptd_except_sts_cd"   "cvg_rptd_except_desc"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6} { PARAM :paramkind 12 :paramid 5 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 5} { PARAM :paramkind 12 :paramid 6 :paramname \<unnamed> :paramtype 1082 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "coverage_step" WHERE "ben_plan_id" = $1 AND "cvgstep_id" = $2 FOR UPDATE OF "coverage_step"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname coverage_step :relid 1288729  :subquery <> :alias <> :eref { ATTR :relname coverage_step :attrs ( "ben_plan_id"   "cvgstep_id"   "cvgstep_hal_step_no"   "cvgstep_hal_evnt_id"   "cvgstep_desc"   "cvgstep_per_emp_flat_amt"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "cvg_rptd" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 AND "rptg_seq_id" = $5 AND "rptg_prd_end_dt" = $6 FOR UPDATE OF "cvg_rptd"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749  :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rptg_prd_end_dt"   "rptg_seq_id"   "rptg_session_id"   "cvg_rptd_sts_cd"   "cvg_rptd_except_sts_cd"   "cvg_rptd_except_desc"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6} { PARAM :paramkind 12 :paramid 5 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 5} { PARAM :paramkind 12 :paramid 6 :paramname \<unnamed> :paramtype 1082 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "coverage_step" WHERE "ben_plan_id" = $1 AND "cvgstep_id" = $2 FOR UPDATE OF "coverage_step"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname coverage_step :relid 1288729  :subquery <> :alias <> :eref { ATTR :relname coverage_step :attrs ( "ben_plan_id"   "cvgstep_id"   "cvgstep_hal_step_no"   "cvgstep_hal_evnt_id"   "cvgstep_desc"   "cvgstep_per_emp_flat_amt"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "cvg_rptd" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 AND "rptg_seq_id" = $5 AND "rptg_prd_end_dt" = $6 FOR UPDATE OF "cvg_rptd"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749  :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rptg_prd_end_dt"   "rptg_seq_id"   "rptg_session_id"   "cvg_rptd_sts_cd"   "cvg_rptd_except_sts_cd"   "cvg_rptd_except_desc"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6} { PARAM :paramkind 12 :paramid 5 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 5} { PARAM :paramkind 12 :paramid 6 :paramname \<unnamed> :paramtype 1082 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "coverage_step" WHERE "ben_plan_id" = $1 AND "cvgstep_id" = $2 FOR UPDATE OF "coverage_step"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname coverage_step :relid 1288729  :subquery <> :alias <> :eref { ATTR :relname coverage_step :attrs ( "ben_plan_id"   "cvgstep_id"   "cvgstep_hal_step_no"   "cvgstep_hal_evnt_id"   "cvgstep_desc"   "cvgstep_per_emp_flat_amt"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  query: SELECT oid FROM ONLY "cvg_rptd" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 AND "rptg_seq_id" = $5 AND "rptg_prd_end_dt" = $6 FOR UPDATE OF "cvg_rptd"
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749  :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rptg_prd_end_dt"   "rptg_seq_id"   "rptg_session_id"   "cvg_rptd_sts_cd"   "cvg_rptd_except_sts_cd"   "cvg_rptd_except_desc"   "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6} { PARAM :paramkind 12 :paramid 5 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 5} { PARAM :paramkind 12 :paramid 6 :paramname \<unnamed> :paramtype 1082 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: update cvg_rptd set rptg_session_id = NULL, cvg_rptd_sts_cd = 0,
cvg_rptd_except_sts_cd = 0, cvg_rptd_except_desc = NULL, mdfy_dt = now()
where emp_grp_id = 'DB1F2BCA-9272-D411-B712-0008C78CB1FE' and
ben_plan_id = 'A0E79587-D136-D411-B5F4-0050DA5FD075' and grp_rate_id =
'F7E6C60E-1979-11D5-AE7D-001083FD6A84' and rate_step_id =
'CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3' and rptg_seq_id =
'3743CB52-2D46-11D5-8A09-00508B0E83B6' and rptg_seq_id =
'3743CB52-2D46-11D5-8A09-00508B0E83B6' and rptg_prd_end_dt =
'2001-04-30';
DEBUG:  parse tree: { QUERY :command 2  :utility <> :resultRelation 1 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749  :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id"   "ben_plan_id"   "grp_rate_id"   "rate_step_id"   "rptg_prd_end_dt"   "rptg_seq_id"   "rptg_session_id"   "cvg_rptd_sts_cd"   "cvg_rptd_except_sts_cd"   "cvg_rptd_except_desc"   "mdfy_dt" )} :inh true :inFromCl false :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ -54 43 31 -37 114 -110 17 -44 -73 18 0 8 -57 -116 -79 -2 ] })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ -121 -107 -25 -96 54 -47 17 -44 -75 -12 0 80 -38 95 -48 117 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ 14 -58 -26 -9 121 25 -43 17 -82 125 0 16 -125 -3 106 -124 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ -57 62 42 -49 -29 -32 -45 17 -87 -69 0 96 -80 104 35 -61 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ 82 -53 67 55 70 45 -43 17 -118 9 0 80 -117 14 -125 -74 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ 82 -53 67 55 70 45 -43 17 -118 9 0 80 -117 14 -125 -74 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 5} { CONST :consttype 1082 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ -27 1 0 0 ] })})}} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 7 :restype 1288591 :restypmod -1 :resname rptg_session_id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull true :constvalue <>}} { TARGETENTRY :resdom { RESDOM :resno 8 :restype 21 :restypmod -1 :resname cvg_rptd_sts_cd :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue  2 [ 0 0 0 0 ] }} { TARGETENTRY :resdom { RESDOM :resno 9 :restype 21 :restypmod -1 :resname cvg_rptd_except_sts_cd :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue  2 [ 0 0 0 0 ] }} { TARGETENTRY :resdom { RESDOM :resno 10 :restype 1043 :restypmod 154 :resname cvg_rptd_except_desc :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { EXPR :typeOid 1043  :opType func :oper { FUNC :funcid 669 :functype 1043 } :args ({ CONST :consttype 1043 :constlen -1 :constbyval false :constisnull true :constvalue <>} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ -102 0 0 0 ] })}} { TARGETENTRY :resdom { RESDOM :resno 11 :restype 1184 :restypmod -1 :resname mdfy_dt :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { EXPR :typeOid 1184  :opType func :oper { FUNC :funcid 1299 :functype 1184 } :args <>}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  ProcessQuery
ERROR:  Relation 2699531655 does not exist
DEBUG:  AbortCurrentTransaction
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
/usr/bin/postmaster: reaping dead processes...
/usr/bin/postmaster: CleanupProc: pid 5312 exited with status 0
