1516: (p_prepay_action_id pay_assignment_actions.assignment_action_id%type,
1517: p_source_action_id pay_assignment_actions.assignment_action_id%type) IS
1518: SELECT paa.assignment_action_id
1519: FROM pay_assignment_actions paa,
1520: pay_action_interlocks pai,
1521: pay_run_types_f prt
1522: WHERE pai.locking_action_id = p_prepay_action_id
1523: and paa.assignment_action_id = pai.locked_action_id
1524: and paa.source_action_id = p_source_action_id
1953: ptp.time_period_id
1954: from pay_assignment_actions paa_arch_chd,
1955: pay_assignment_actions paa_arch_mst,
1956: pay_assignment_actions paa_pre,
1957: pay_action_interlocks pai_pre,
1958: pay_assignment_actions paa_run,
1959: pay_action_interlocks pai_run,
1960: pay_payroll_actions ppa_pre,
1961: pay_payroll_actions ppa_run,
1955: pay_assignment_actions paa_arch_mst,
1956: pay_assignment_actions paa_pre,
1957: pay_action_interlocks pai_pre,
1958: pay_assignment_actions paa_run,
1959: pay_action_interlocks pai_run,
1960: pay_payroll_actions ppa_pre,
1961: pay_payroll_actions ppa_run,
1962: per_time_periods ptp
1963: where paa_arch_mst.assignment_action_id = p_master_aa_id
1977: and ptp.end_date
1978: -- Get the highest in sequence for this payslip
1979: and paa_run.action_sequence = (select max(paa_run2.action_sequence)
1980: from pay_assignment_actions paa_run2,
1981: pay_action_interlocks pai_run2
1982: where pai_run2.locking_action_id =
1983: paa_arch_chd.assignment_action_id
1984: and pai_run2.locked_action_id =
1985: paa_run2.assignment_action_id