DBA Data[Home] [Help]

APPS.PAY_KR_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 715: pay_action_interlocks pai_pre,

711: paa_run.tax_unit_id tax_unit_id
712: FROM pay_assignment_actions paa_arch_chd,
713: pay_assignment_actions paa_arch_mst,
714: pay_assignment_actions paa_pre,
715: pay_action_interlocks pai_pre,
716: pay_assignment_actions paa_run,
717: pay_action_interlocks pai_run,
718: pay_payroll_actions ppa_pre,
719: pay_payroll_actions ppa_run,

Line 717: pay_action_interlocks pai_run,

713: pay_assignment_actions paa_arch_mst,
714: pay_assignment_actions paa_pre,
715: pay_action_interlocks pai_pre,
716: pay_assignment_actions paa_run,
717: pay_action_interlocks pai_run,
718: pay_payroll_actions ppa_pre,
719: pay_payroll_actions ppa_run,
720: per_time_periods ptp
721: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id

Line 739: pay_action_interlocks pai_run2

735: AND ptp.end_date
736: -- Get the highest in sequence for this payslip
737: AND paa_run.action_sequence = (SELECT max(paa_run2.action_sequence)
738: FROM pay_assignment_actions paa_run2,
739: pay_action_interlocks pai_run2
740: WHERE pai_run2.locking_action_id =
741: paa_arch_chd.assignment_action_id
742: AND pai_run2.locked_action_id =
743: paa_run2.assignment_action_id