APPS.PAY_GTNLOD_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 1706: pay_action_interlocks pai

1702: select ppp.pre_payment_id pre_payment_id
1703: from pay_pre_payments ppp,
1704: pay_payroll_actions ppa_ppp,
1705: pay_assignment_actions paa_ppp,
1706: pay_action_interlocks pai
1707: where pai.locked_action_id = l_assignment_action_id
1708: and paa_ppp.assignment_action_id = pai.locking_action_id
1709: and paa_ppp.action_status = 'C'
1710: and ppa_ppp.payroll_action_id = paa_ppp.payroll_action_id

Line 1820: pay_action_interlocks pai

1816: select 'X'
1817: into l_dummy_var
1818: from pay_payroll_actions ppa_ppp,
1819: pay_assignment_actions paa_ppp,
1820: pay_action_interlocks pai
1821: where pai.locked_action_id = l_assignment_action_id
1822: and paa_ppp.assignment_action_id = pai.locking_action_id
1823: and paa_ppp.action_status = 'C'
1824: and ppa_ppp.payroll_action_id = paa_ppp.payroll_action_id

Line 1885: PAY_ACTION_INTERLOCKS PAI_RUN,

1881: PPP.VALUE VALUE,
1882: PPP.PRE_PAYMENT_ID PMT_ID
1883: from PAY_PAYROLL_ACTIONS PPA_PPP,
1884: PAY_ASSIGNMENT_ACTIONS PAA_PPP,
1885: PAY_ACTION_INTERLOCKS PAI_RUN,
1886: PAY_PAYROLL_ACTIONS PPA_CHK,
1887: PAY_ASSIGNMENT_ACTIONS PAA_CHK,
1888: PAY_ACTION_INTERLOCKS PAI_CHK,
1889: PAY_ORG_PAYMENT_METHODS_F POPM,

Line 1888: PAY_ACTION_INTERLOCKS PAI_CHK,

1884: PAY_ASSIGNMENT_ACTIONS PAA_PPP,
1885: PAY_ACTION_INTERLOCKS PAI_RUN,
1886: PAY_PAYROLL_ACTIONS PPA_CHK,
1887: PAY_ASSIGNMENT_ACTIONS PAA_CHK,
1888: PAY_ACTION_INTERLOCKS PAI_CHK,
1889: PAY_ORG_PAYMENT_METHODS_F POPM,
1890: PAY_PRE_PAYMENTS PPP
1891: WHERE PAI_RUN.LOCKED_ACTION_ID = p_max_seq_aaid
1892: AND PAI_RUN.LOCKING_ACTION_ID = PAA_PPP.ASSIGNMENT_ACTION_ID

Line 1912: PAY_ACTION_INTERLOCKS PAI_VOID

1908: AND NOT EXISTS
1909: (SELECT NULL
1910: FROM PAY_PAYROLL_ACTIONS PPA_VOID,
1911: PAY_ASSIGNMENT_ACTIONS PAA_VOID,
1912: PAY_ACTION_INTERLOCKS PAI_VOID
1913: WHERE PAI_VOID.LOCKED_ACTION_ID = PAA_CHK.ASSIGNMENT_ACTION_ID
1914: AND PAA_VOID.ASSIGNMENT_ACTION_ID = PAI_VOID.LOCKING_ACTION_ID
1915: AND PAA_VOID.ACTION_STATUS = 'C'
1916: AND PPA_VOID.PAYROLL_ACTION_ID = PAA_VOID.PAYROLL_ACTION_ID

Line 2363: pay_action_interlocks pai,

2359: hr_all_organization_units hou,
2360: per_assignments_f paf,
2361: pay_payroll_actions ppa,
2362: pay_assignment_actions paa1,
2363: pay_action_interlocks pai,
2364: pay_assignment_actions paa,
2365: pay_payroll_actions ppa_arch
2366: where ppa_arch.payroll_action_id = l_pactid
2367: and paa.payroll_action_id = ppa_arch.payroll_action_id