APPS.PAY_GTNLOD_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 1885: pay_action_interlocks pai

1881: select ppp.pre_payment_id pre_payment_id
1882: from pay_pre_payments ppp,
1883: pay_payroll_actions ppa_ppp,
1884: pay_assignment_actions paa_ppp,
1885: pay_action_interlocks pai
1886: where pai.locked_action_id = l_assignment_action_id
1887: and paa_ppp.assignment_action_id = pai.locking_action_id
1888: and paa_ppp.action_status = 'C'
1889: and ppa_ppp.payroll_action_id = paa_ppp.payroll_action_id

Line 1999: pay_action_interlocks pai

1995: select 'X'
1996: into l_dummy_var
1997: from pay_payroll_actions ppa_ppp,
1998: pay_assignment_actions paa_ppp,
1999: pay_action_interlocks pai
2000: where pai.locked_action_id = l_assignment_action_id
2001: and paa_ppp.assignment_action_id = pai.locking_action_id
2002: and paa_ppp.action_status = 'C'
2003: and ppa_ppp.payroll_action_id = paa_ppp.payroll_action_id

Line 2064: PAY_ACTION_INTERLOCKS PAI_RUN,

2060: PPP.VALUE VALUE,
2061: PPP.PRE_PAYMENT_ID PMT_ID
2062: from PAY_PAYROLL_ACTIONS PPA_PPP,
2063: PAY_ASSIGNMENT_ACTIONS PAA_PPP,
2064: PAY_ACTION_INTERLOCKS PAI_RUN,
2065: PAY_PAYROLL_ACTIONS PPA_CHK,
2066: PAY_ASSIGNMENT_ACTIONS PAA_CHK,
2067: PAY_ACTION_INTERLOCKS PAI_CHK,
2068: PAY_ORG_PAYMENT_METHODS_F POPM,

Line 2067: PAY_ACTION_INTERLOCKS PAI_CHK,

2063: PAY_ASSIGNMENT_ACTIONS PAA_PPP,
2064: PAY_ACTION_INTERLOCKS PAI_RUN,
2065: PAY_PAYROLL_ACTIONS PPA_CHK,
2066: PAY_ASSIGNMENT_ACTIONS PAA_CHK,
2067: PAY_ACTION_INTERLOCKS PAI_CHK,
2068: PAY_ORG_PAYMENT_METHODS_F POPM,
2069: PAY_PRE_PAYMENTS PPP
2070: WHERE PAI_RUN.LOCKED_ACTION_ID = p_max_seq_aaid
2071: AND PAI_RUN.LOCKING_ACTION_ID = PAA_PPP.ASSIGNMENT_ACTION_ID

Line 2091: PAY_ACTION_INTERLOCKS PAI_VOID

2087: AND NOT EXISTS
2088: (SELECT NULL
2089: FROM PAY_PAYROLL_ACTIONS PPA_VOID,
2090: PAY_ASSIGNMENT_ACTIONS PAA_VOID,
2091: PAY_ACTION_INTERLOCKS PAI_VOID
2092: WHERE PAI_VOID.LOCKED_ACTION_ID = PAA_CHK.ASSIGNMENT_ACTION_ID
2093: AND PAA_VOID.ASSIGNMENT_ACTION_ID = PAI_VOID.LOCKING_ACTION_ID
2094: AND PAA_VOID.ACTION_STATUS = 'C'
2095: AND PPA_VOID.PAYROLL_ACTION_ID = PAA_VOID.PAYROLL_ACTION_ID

Line 2546: pay_action_interlocks pai,

2542: hr_all_organization_units hou,
2543: per_assignments_f paf,
2544: pay_payroll_actions ppa,
2545: pay_assignment_actions paa1,
2546: pay_action_interlocks pai,
2547: pay_assignment_actions paa,
2548: pay_payroll_actions ppa_arch
2549: where ppa_arch.payroll_action_id = l_pactid
2550: and paa.payroll_action_id = ppa_arch.payroll_action_id