DBA Data[Home] [Help]

APPS.PAY_NZ_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 895: ,pay_action_interlocks pai_pre

891: ,ptp.regular_payment_date
892: FROM pay_assignment_actions paa_arch_chd
893: ,pay_assignment_actions paa_arch_mst
894: ,pay_assignment_actions paa_pre
895: ,pay_action_interlocks pai_pre
896: ,pay_assignment_actions paa_run
897: ,pay_action_interlocks pai_run
898: ,pay_payroll_actions ppa_pre
899: ,pay_payroll_actions ppa_run

Line 897: ,pay_action_interlocks pai_run

893: ,pay_assignment_actions paa_arch_mst
894: ,pay_assignment_actions paa_pre
895: ,pay_action_interlocks pai_pre
896: ,pay_assignment_actions paa_run
897: ,pay_action_interlocks pai_run
898: ,pay_payroll_actions ppa_pre
899: ,pay_payroll_actions ppa_run
900: ,per_time_periods ptp
901: ,per_business_groups pbg

Line 925: ,pay_action_interlocks pai_run2

921: AND paa_run.action_sequence =
922: (
923: SELECT MAX(paa_run2.action_sequence)
924: FROM pay_assignment_actions paa_run2
925: ,pay_action_interlocks pai_run2
926: WHERE pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
927: AND pai_run2.locked_action_id = paa_run2.assignment_action_id
928: );
929: