APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 727: ,pay_action_interlocks pai

723: , pay_input_values_f piv
724: , pay_element_types_f pet
725: , pay_element_types_f_tl petl
726: , pay_element_classifications pec
727: ,pay_action_interlocks pai
728: WHERE ppa.action_type in ('R','Q')
729: AND ppa.action_status = 'C'
730: AND ppa.payroll_action_id = paa.payroll_action_id
731: AND paa.assignment_action_id = prr.assignment_action_id

Line 2164: ,pay_action_interlocks pai_pre

2160: ,ptp.regular_payment_date
2161: FROM pay_assignment_actions paa_arch_chd
2162: ,pay_assignment_actions paa_arch_mst
2163: ,pay_assignment_actions paa_pre
2164: ,pay_action_interlocks pai_pre
2165: ,pay_assignment_actions paa_run
2166: ,pay_action_interlocks pai_run
2167: ,pay_payroll_actions ppa_pre
2168: ,pay_payroll_actions ppa_run

Line 2166: ,pay_action_interlocks pai_run

2162: ,pay_assignment_actions paa_arch_mst
2163: ,pay_assignment_actions paa_pre
2164: ,pay_action_interlocks pai_pre
2165: ,pay_assignment_actions paa_run
2166: ,pay_action_interlocks pai_run
2167: ,pay_payroll_actions ppa_pre
2168: ,pay_payroll_actions ppa_run
2169: ,per_time_periods ptp
2170: ,per_business_groups pbg

Line 2194: ,pay_action_interlocks pai_run2

2190: AND paa_run.action_sequence =
2191: (
2192: SELECT MAX(paa_run2.action_sequence)
2193: FROM pay_assignment_actions paa_run2
2194: ,pay_action_interlocks pai_run2
2195: WHERE pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
2196: AND pai_run2.locked_action_id = paa_run2.assignment_action_id
2197: );
2198: