APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 629: ,pay_action_interlocks pai

625: , pay_input_values_f piv
626: , pay_element_types_f pet
627: , pay_element_types_f_tl petl
628: , pay_element_classifications pec
629: ,pay_action_interlocks pai
630: WHERE ppa.action_type in ('R','Q')
631: AND ppa.action_status = 'C'
632: AND ppa.payroll_action_id = paa.payroll_action_id
633: AND paa.assignment_action_id = prr.assignment_action_id

Line 2036: ,pay_action_interlocks pai_pre

2032: ,ptp.regular_payment_date
2033: FROM pay_assignment_actions paa_arch_chd
2034: ,pay_assignment_actions paa_arch_mst
2035: ,pay_assignment_actions paa_pre
2036: ,pay_action_interlocks pai_pre
2037: ,pay_assignment_actions paa_run
2038: ,pay_action_interlocks pai_run
2039: ,pay_payroll_actions ppa_pre
2040: ,pay_payroll_actions ppa_run

Line 2038: ,pay_action_interlocks pai_run

2034: ,pay_assignment_actions paa_arch_mst
2035: ,pay_assignment_actions paa_pre
2036: ,pay_action_interlocks pai_pre
2037: ,pay_assignment_actions paa_run
2038: ,pay_action_interlocks pai_run
2039: ,pay_payroll_actions ppa_pre
2040: ,pay_payroll_actions ppa_run
2041: ,per_time_periods ptp
2042: ,per_business_groups pbg

Line 2066: ,pay_action_interlocks pai_run2

2062: AND paa_run.action_sequence =
2063: (
2064: SELECT MAX(paa_run2.action_sequence)
2065: FROM pay_assignment_actions paa_run2
2066: ,pay_action_interlocks pai_run2
2067: WHERE pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
2068: AND pai_run2.locked_action_id = paa_run2.assignment_action_id
2069: );
2070: