DBA Data[Home] [Help]

APPS.PAY_SG_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 803: pay_action_interlocks pai_pre,

799: ptp.time_period_id
800: from pay_assignment_actions paa_arch_chd,
801: pay_assignment_actions paa_arch_mst,
802: pay_assignment_actions paa_pre,
803: pay_action_interlocks pai_pre,
804: pay_assignment_actions paa_run,
805: pay_action_interlocks pai_run,
806: pay_payroll_actions ppa_pre,
807: pay_payroll_actions ppa_run,

Line 805: pay_action_interlocks pai_run,

801: pay_assignment_actions paa_arch_mst,
802: pay_assignment_actions paa_pre,
803: pay_action_interlocks pai_pre,
804: pay_assignment_actions paa_run,
805: pay_action_interlocks pai_run,
806: pay_payroll_actions ppa_pre,
807: pay_payroll_actions ppa_run,
808: per_time_periods ptp
809: where paa_arch_mst.assignment_action_id = p_master_aa_id

Line 827: pay_action_interlocks pai_run2

823: and ptp.end_date
824: -- Get the highest in sequence for this payslip
825: and paa_run.action_sequence = (select max(paa_run2.action_sequence)
826: from pay_assignment_actions paa_run2,
827: pay_action_interlocks pai_run2
828: where pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
829: and pai_run2.locked_action_id = paa_run2.assignment_action_id
830: );
831: