APPS.PAY_SG_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 809: pay_action_interlocks pai_pre,

805: ptp.time_period_id
806: from pay_assignment_actions paa_arch_chd,
807: pay_assignment_actions paa_arch_mst,
808: pay_assignment_actions paa_pre,
809: pay_action_interlocks pai_pre,
810: pay_assignment_actions paa_run,
811: pay_action_interlocks pai_run,
812: pay_payroll_actions ppa_pre,
813: pay_payroll_actions ppa_run,

Line 811: pay_action_interlocks pai_run,

807: pay_assignment_actions paa_arch_mst,
808: pay_assignment_actions paa_pre,
809: pay_action_interlocks pai_pre,
810: pay_assignment_actions paa_run,
811: pay_action_interlocks pai_run,
812: pay_payroll_actions ppa_pre,
813: pay_payroll_actions ppa_run,
814: per_time_periods ptp
815: where paa_arch_mst.assignment_action_id = p_master_aa_id

Line 833: pay_action_interlocks pai_run2

829: and ptp.end_date
830: -- Get the highest in sequence for this payslip
831: and paa_run.action_sequence = (select max(paa_run2.action_sequence)
832: from pay_assignment_actions paa_run2,
833: pay_action_interlocks pai_run2
834: where pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
835: and pai_run2.locked_action_id = paa_run2.assignment_action_id
836: );
837: