DBA Data[Home] [Help]

APPS.PAY_PAYWSQEE_PKG dependencies on PAY_BATCH_CONTROL_TOTALS

Line 831: from pay_batch_control_totals

827: header_processing boolean := FALSE;
828: --
829: cursor csr_status is
830: select control_status STATUS
831: from pay_batch_control_totals
832: where batch_id = p_batch_id
833: union
834: select batch_line_status
835: from pay_batch_lines

Line 848: -- from pay_batch_control_totals ctl

844: where bth.batch_id = p_batch_id
845: and bth.batch_status = 'T'
846: -- and not exists
847: -- (select null
848: -- from pay_batch_control_totals ctl
849: -- where ctl.batch_id = bth.batch_id
850: -- and ctl.control_status <> 'T')
851: order by 1 desc;
852: --