APPS.PAY_HK_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 1002: pay_action_interlocks pai_pre,

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

Line 1004: pay_action_interlocks pai_run,

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

Line 1026: pay_action_interlocks pai_run2

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