[Home] [Help]
1780: act1.assignment_action_id prepaid_action_id
1781: FROM pay_payroll_actions ppa,
1782: pay_payroll_actions appa,
1783: pay_payroll_actions appa2,
1784: pay_assignment_actions act,
1785: pay_assignment_actions act1,
1786: pay_action_interlocks pai,
1787: per_all_assignments_f as1
1788: WHERE ppa.payroll_action_id = p_pact_id
1781: FROM pay_payroll_actions ppa,
1782: pay_payroll_actions appa,
1783: pay_payroll_actions appa2,
1784: pay_assignment_actions act,
1785: pay_assignment_actions act1,
1786: pay_action_interlocks pai,
1787: per_all_assignments_f as1
1788: WHERE ppa.payroll_action_id = p_pact_id
1789: AND appa.consolidation_set_id = p_consolidation_id
1805: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
1806: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
1807: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
1808: FROM pay_action_interlocks pai1,
1809: pay_assignment_actions act2,
1810: pay_payroll_actions appa3
1811: WHERE pai1.locked_action_id = act.assignment_action_id
1812: AND act2.assignment_action_id = pai1.locking_action_id
1813: AND act2.payroll_action_id = appa3.payroll_action_id
1828: act1.assignment_action_id prepaid_action_id
1829: FROM pay_payroll_actions ppa,
1830: pay_payroll_actions appa,
1831: pay_payroll_actions appa2,
1832: pay_assignment_actions act,
1833: pay_assignment_actions act1,
1834: pay_action_interlocks pai,
1835: per_all_assignments_f as1,
1836: pay_population_ranges ppr
1829: FROM pay_payroll_actions ppa,
1830: pay_payroll_actions appa,
1831: pay_payroll_actions appa2,
1832: pay_assignment_actions act,
1833: pay_assignment_actions act1,
1834: pay_action_interlocks pai,
1835: per_all_assignments_f as1,
1836: pay_population_ranges ppr
1837: WHERE ppa.payroll_action_id = p_pact_id
1855: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
1856: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
1857: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
1858: FROM pay_action_interlocks pai1,
1859: pay_assignment_actions act2,
1860: pay_payroll_actions appa3
1861: WHERE pai1.locked_action_id = act.assignment_action_id
1862: AND act2.assignment_action_id = pai1.locking_action_id
1863: AND act2.payroll_action_id = appa3.payroll_action_id
1919: FOR csr_rec IN csr_range_pre_assignments(pactid, l_payroll_id, l_consolidation_set)
1920: LOOP
1921: IF l_prepay_action_id <> csr_rec.prepaid_action_id THEN
1922: --
1923: SELECT pay_assignment_actions_s.NEXTVAL
1924: INTO l_actid
1925: FROM dual;
1926: --
1927: -- Create the archive assignment action for master action
1956: IF l_prepay_action_id <> csr_rec.prepaid_action_id
1957:
1958: THEN
1959:
1960: SELECT pay_assignment_actions_s.NEXTVAL
1961: INTO l_actid
1962: FROM dual;
1963:
1964: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
2002: FROM pay_action_interlocks pre,
2003: pay_action_interlocks pay,
2004: pay_payroll_actions paa,
2005: pay_payroll_actions ppaa,
2006: pay_assignment_actions assact,
2007: pay_assignment_actions passact
2008: WHERE pre.locked_action_id = pay.locking_action_id
2009: AND pre.locking_action_id = p_locking_action_id
2010: AND pre.locked_action_id = passact.assignment_action_id
2003: pay_action_interlocks pay,
2004: pay_payroll_actions paa,
2005: pay_payroll_actions ppaa,
2006: pay_assignment_actions assact,
2007: pay_assignment_actions passact
2008: WHERE pre.locked_action_id = pay.locking_action_id
2009: AND pre.locking_action_id = p_locking_action_id
2010: AND pre.locked_action_id = passact.assignment_action_id
2011: AND passact.payroll_action_id = ppaa.payroll_action_id
2020: p_assignment_id NUMBER,
2021: p_effective_date DATE ) IS
2022: SELECT paa.assignment_action_id child_assignment_action_id,
2023: 'S' run_type
2024: FROM pay_assignment_actions paa,
2025: pay_run_types_f prt
2026: WHERE paa.source_action_id = p_master_assignment_action
2027: AND paa.payroll_action_id = p_payroll_action_id
2028: AND paa.assignment_id = p_assignment_id
2032: prt.effective_start_date AND prt.effective_end_date
2033: UNION
2034: SELECT paa.assignment_action_id child_assignment_action_id,
2035: 'NP' run_type
2036: FROM pay_assignment_actions paa
2037: WHERE paa.payroll_action_id = p_payroll_action_id
2038: AND paa.assignment_id = p_assignment_id
2039: AND paa.action_sequence = (SELECT MAX(paa1.action_sequence)
2040: FROM pay_assignment_actions paa1,
2036: FROM pay_assignment_actions paa
2037: WHERE paa.payroll_action_id = p_payroll_action_id
2038: AND paa.assignment_id = p_assignment_id
2039: AND paa.action_sequence = (SELECT MAX(paa1.action_sequence)
2040: FROM pay_assignment_actions paa1,
2041: pay_run_types_f prt1
2042: WHERE prt1.run_type_id = paa1.run_type_id
2043: AND prt1.run_method IN ('N','P')
2044: AND paa1.payroll_action_id = p_payroll_action_id
2052: p_assignment_id NUMBER,
2053: p_effective_date DATE) IS
2054: SELECT paa.assignment_action_id np_assignment_action_id,
2055: prt.run_method
2056: FROM pay_assignment_actions paa,
2057: pay_run_types_f prt
2058: WHERE paa.source_action_id = p_assignment_action_id
2059: AND paa.payroll_action_id = p_payroll_action_id
2060: AND paa.assignment_id = p_assignment_id
2091:
2092: -- retrieve the chunk number for the current assignment action
2093: SELECT paa.chunk_number
2094: INTO l_chunk_number
2095: FROM pay_assignment_actions paa
2096: WHERE paa.assignment_action_id = p_assactid;
2097:
2098: l_action_context_id := p_assactid;
2099:
2161: csr_rec.effective_date)
2162:
2163: LOOP
2164: -- create additional archive assignment actions and interlocks
2165: SELECT pay_assignment_actions_s.NEXTVAL
2166: INTO l_actid
2167: FROM dual;
2168:
2169: hr_utility.set_location('csr_child_rec.run_type = ' ||