APPS.PAY_AU_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 1355: pay_action_interlocks pai,

1351: (p_prepay_action_id pay_assignment_actions.assignment_action_id%type,
1352: p_source_action_id pay_assignment_actions.assignment_action_id%type) IS
1353: SELECT paa.assignment_action_id
1354: FROM pay_assignment_actions paa,
1355: pay_action_interlocks pai,
1356: pay_run_types_f prt
1357: WHERE pai.locking_action_id = p_prepay_action_id
1358: and paa.assignment_action_id = pai.locked_action_id
1359: and paa.source_action_id = p_source_action_id

Line 1670: pay_action_interlocks pai_pre,

1666: ptp.time_period_id
1667: from pay_assignment_actions paa_arch_chd,
1668: pay_assignment_actions paa_arch_mst,
1669: pay_assignment_actions paa_pre,
1670: pay_action_interlocks pai_pre,
1671: pay_assignment_actions paa_run,
1672: pay_action_interlocks pai_run,
1673: pay_payroll_actions ppa_pre,
1674: pay_payroll_actions ppa_run,

Line 1672: pay_action_interlocks pai_run,

1668: pay_assignment_actions paa_arch_mst,
1669: pay_assignment_actions paa_pre,
1670: pay_action_interlocks pai_pre,
1671: pay_assignment_actions paa_run,
1672: pay_action_interlocks pai_run,
1673: pay_payroll_actions ppa_pre,
1674: pay_payroll_actions ppa_run,
1675: per_time_periods ptp
1676: where paa_arch_mst.assignment_action_id = p_master_aa_id

Line 1694: pay_action_interlocks pai_run2

1690: and ptp.end_date
1691: -- Get the highest in sequence for this payslip
1692: and paa_run.action_sequence = (select max(paa_run2.action_sequence)
1693: from pay_assignment_actions paa_run2,
1694: pay_action_interlocks pai_run2
1695: where pai_run2.locking_action_id =
1696: paa_arch_chd.assignment_action_id
1697: and pai_run2.locked_action_id =
1698: paa_run2.assignment_action_id