[Home] [Help]
1808: CURSOR csr_prev_payroll_exists(c_assignment_action_id NUMBER
1809: ,c_assignment_id NUMBER
1810: ,c_start_date DATE
1811: ,c_end_date DATE)IS
1812: SELECT 'DP' FROM dual
1813: WHERE EXISTS (SELECT 1
1814: FROM pay_assignment_actions paa1
1815: ,pay_assignment_actions paa2
1816: ,pay_payroll_actions ppa
1826: CURSOR csr_diff_de_dp(c_payroll_action_id NUMBER
1827: ,c_assignment_id NUMBER
1828: ,c_start_date DATE
1829: ,c_end_date DATE)IS
1830: SELECT 'DE' FROM dual
1831: WHERE EXISTS (SELECT 1
1832: FROM pay_assignment_actions paa
1833: ,pay_payroll_actions ppa
1834: WHERE paa.assignment_id = c_assignment_id
1873: --
1874: CURSOR csr_chk_element_entry(c_parent_id NUMBER
1875: ,c_eff_date DATE) IS
1876: SELECT 'Y'
1877: FROM dual
1878: WHERE exists (SELECT 1
1879: FROM pay_object_groups pog
1880: ,pay_element_entries_f peef
1881: ,pay_element_types_f petf
1994: CURSOR csr_prev_payroll_exists(c_assignment_action_id NUMBER
1995: ,c_assignment_id NUMBER
1996: ,c_start_date DATE
1997: ,c_end_date DATE)IS
1998: SELECT 'DP' FROM dual
1999: WHERE EXISTS (SELECT 1
2000: FROM pay_assignment_actions paa1
2001: ,pay_assignment_actions paa2
2002: ,pay_payroll_actions ppa
2012: CURSOR csr_diff_de_dp(c_payroll_action_id NUMBER
2013: ,c_assignment_id NUMBER
2014: ,c_start_date DATE
2015: ,c_end_date DATE)IS
2016: SELECT 'DE' FROM dual
2017: WHERE EXISTS (SELECT 1
2018: FROM pay_assignment_actions paa
2019: ,pay_payroll_actions ppa
2020: WHERE paa.assignment_id = c_assignment_id
2058: --
2059: CURSOR csr_chk_element_entry(c_parent_id NUMBER
2060: ,c_eff_date DATE) IS
2061: SELECT 'Y'
2062: FROM dual
2063: WHERE exists (SELECT 1
2064: FROM pay_object_groups pog
2065: ,pay_element_entries_f peef
2066: ,pay_element_types_f petf
2180: /*
2181: CURSOR csr_prev_qtd_payroll_exists(c_assignment_action_id NUMBER
2182: ,c_start_date DATE
2183: ,c_end_date DATE)IS
2184: SELECT 'DP' FROM dual
2185: WHERE EXISTS (SELECT 1
2186: FROM pay_assignment_actions paa1
2187: ,pay_assignment_actions paa2
2188: ,pay_payroll_actions ppa
2196: --
2197: CURSOR csr_prev_lqtd_payroll_exists(c_assignment_action_id NUMBER
2198: ,c_start_date DATE
2199: ,c_end_date DATE)IS
2200: SELECT 'DP' FROM dual
2201: WHERE EXISTS (SELECT 1
2202: FROM pay_assignment_actions paa1
2203: ,pay_assignment_actions paa2
2204: ,pay_payroll_actions ppa
2215: CURSOR csr_diff_de_dp_qtd(c_payroll_action_id NUMBER
2216: ,c_assignment_action_id NUMBER
2217: ,c_start_date DATE
2218: ,c_end_date DATE)IS
2219: SELECT 'DE' FROM dual
2220: WHERE EXISTS (SELECT 1
2221: FROM pay_assignment_actions paa1
2222: ,pay_assignment_actions paa2
2223: ,pay_payroll_actions ppa1
2236: CURSOR csr_diff_de_dp_lqtd(c_payroll_action_id NUMBER
2237: ,c_assignment_action_id NUMBER
2238: ,c_start_date DATE
2239: ,c_end_date DATE)IS
2240: SELECT 'DE' FROM dual
2241: WHERE EXISTS (SELECT 1
2242: FROM pay_assignment_actions paa1
2243: ,pay_assignment_actions paa2
2244: ,pay_payroll_actions ppa1
2269: --
2270: CURSOR csr_chk_pog_exist(c_assignment_id NUMBER
2271: ,c_start_date DATE
2272: ,c_end_date DATE) IS
2273: SELECT '1' FROM DUAL
2274: WHERE EXISTS (SELECT 1
2275: FROM pay_object_groups pog1
2276: ,pay_object_groups pog2
2277: WHERE pog1.source_id = c_assignment_id
2289: --
2290: CURSOR csr_chk_element_entry(c_ass_id NUMBER
2291: ,c_eff_date DATE) IS
2292: SELECT 'Y'
2293: FROM dual
2294: WHERE exists (SELECT 1
2295: FROM pay_element_entries_f peef
2296: ,pay_element_types_f petf
2297: WHERE peef.assignment_id = c_ass_id
2419: --
2420: CURSOR csr_prev_qtd_payroll_exists(c_assignment_action_id NUMBER
2421: ,c_start_date DATE
2422: ,c_end_date DATE)IS
2423: SELECT 'DP' FROM dual
2424: WHERE EXISTS (SELECT 1
2425: FROM pay_assignment_actions paa1
2426: ,pay_assignment_actions paa2
2427: ,pay_payroll_actions ppa
2435: --
2436: CURSOR csr_prev_lqtd_payroll_exists(c_assignment_action_id NUMBER
2437: ,c_start_date DATE
2438: ,c_end_date DATE)IS
2439: SELECT 'DP' FROM dual
2440: WHERE EXISTS (SELECT 1
2441: FROM pay_assignment_actions paa1
2442: ,pay_assignment_actions paa2
2443: ,pay_payroll_actions ppa
2454: CURSOR csr_diff_de_dp_qtd(c_payroll_action_id NUMBER
2455: ,c_assignment_action_id NUMBER
2456: ,c_start_date DATE
2457: ,c_end_date DATE)IS
2458: SELECT 'DE' FROM dual
2459: WHERE EXISTS (SELECT 1
2460: FROM pay_assignment_actions paa1
2461: ,pay_assignment_actions paa2
2462: ,pay_payroll_actions ppa1
2475: CURSOR csr_diff_de_dp_lqtd(c_payroll_action_id NUMBER
2476: ,c_assignment_action_id NUMBER
2477: ,c_start_date DATE
2478: ,c_end_date DATE)IS
2479: SELECT 'DE' FROM dual
2480: WHERE EXISTS (SELECT 1
2481: FROM pay_assignment_actions paa1
2482: ,pay_assignment_actions paa2
2483: ,pay_payroll_actions ppa1
2507: --
2508: CURSOR csr_chk_pog_exist(c_assignment_id NUMBER
2509: ,c_start_date DATE
2510: ,c_end_date DATE) IS
2511: SELECT '1' FROM DUAL
2512: WHERE EXISTS (SELECT 1
2513: FROM pay_object_groups pog1
2514: ,pay_object_groups pog2
2515: WHERE pog1.source_id = c_assignment_id
2527: --
2528: CURSOR csr_chk_element_entry(c_ass_id NUMBER
2529: ,c_eff_date DATE) IS
2530: SELECT 'Y'
2531: FROM dual
2532: WHERE exists (SELECT 1
2533: FROM pay_element_entries_f peef
2534: ,pay_element_types_f petf
2535: WHERE peef.assignment_id = c_ass_id
2937: END IF;
2938:
2939: INSERT INTO pay_patch_status
2940: (id,patch_number,patch_name,phase,applied_date,legislation_code)
2941: SELECT pay_patch_status_s.nextval,9453856,'NL_9453856','C',sysdate,'NL' FROM dual;
2942:
2943: END IF;
2944:
2945: hr_utility.set_location('Leaving NL_ADJUST_TO_CORRECTION',320);