APPS.PAY_HK_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 1003: pay_action_interlocks pai_pre,

999: ptp.time_period_id
1000: from pay_assignment_actions paa_arch_chd,
1001: pay_assignment_actions paa_arch_mst,
1002: pay_assignment_actions paa_pre,
1003: pay_action_interlocks pai_pre,
1004: pay_assignment_actions paa_run,
1005: pay_action_interlocks pai_run,
1006: pay_payroll_actions ppa_pre,
1007: pay_payroll_actions ppa_run,

Line 1005: pay_action_interlocks pai_run,

1001: pay_assignment_actions paa_arch_mst,
1002: pay_assignment_actions paa_pre,
1003: pay_action_interlocks pai_pre,
1004: pay_assignment_actions paa_run,
1005: pay_action_interlocks pai_run,
1006: pay_payroll_actions ppa_pre,
1007: pay_payroll_actions ppa_run,
1008: per_time_periods ptp
1009: where paa_arch_mst.assignment_action_id = p_master_aa_id

Line 1027: pay_action_interlocks pai_run2

1023: and ptp.end_date
1024: -- Get the highest in sequence for this payslip
1025: and paa_run.action_sequence = (select max(paa_run2.action_sequence)
1026: from pay_assignment_actions paa_run2,
1027: pay_action_interlocks pai_run2
1028: where pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
1029: and pai_run2.locked_action_id = paa_run2.assignment_action_id
1030: );
1031: