DBA Data[Home] [Help]

APPS.PAY_CORE_UPGRADE_PKG dependencies on PAY_QUICKPAY_INCLUSIONS

Line 860: from pay_quickpay_inclusions

856: --
857: cursor csr_qpay_inclusions
858: is
859: select 'TRUE'
860: from pay_quickpay_inclusions
861: where rownum = 1;
862: --
863: l_inclusions_exist varchar2(10) := 'FALSE';
864: --

Line 914: -- PAY_QUICKPAY_INCLUSIONS...

910: AND PAY_ACTION.date_earned BETWEEN ET.effective_start_date
911: AND ET.effective_end_date
912: --
913: -- Create exclusions for all entries that do not exist in
914: -- PAY_QUICKPAY_INCLUSIONS...
915: --
916: AND NOT EXISTS (
917: SELECT 'x'
918: FROM pay_quickpay_inclusions qi

Line 918: FROM pay_quickpay_inclusions qi

914: -- PAY_QUICKPAY_INCLUSIONS...
915: --
916: AND NOT EXISTS (
917: SELECT 'x'
918: FROM pay_quickpay_inclusions qi
919: WHERE qi.assignment_action_id = ASGT_ACTION.assignment_action_id
920: AND qi.element_entry_id = EE.element_entry_id
921: )
922: --