APPS.PAY_AU_RETRO_UPGRADE dependencies on DUAL

Line 1304: from dual;

1300: IF c_retro_comp_exists%NOTFOUND THEN
1301:
1302: select pay_retro_component_usages_s.nextval
1303: into ln_retro_component_usage_id
1304: from dual;
1305:
1306: insert into pay_retro_component_usages
1307: (retro_component_usage_id, retro_component_id, creator_id, creator_type,
1308: default_component, reprocess_type, business_group_id, legislation_code,

Line 2374: FROM dual;

2370: --
2371: CURSOR csr_get_defn_id
2372: IS
2373: SELECT pay_retro_definitions_s.nextval
2374: FROM dual;
2375: --
2376: BEGIN
2377: --
2378: OPEN csr_defn_exists;

Line 2438: FROM dual;

2434: --
2435: CURSOR csr_get_comp_id
2436: IS
2437: SELECT pay_retro_components_s.nextval
2438: FROM dual;
2439: --
2440: BEGIN
2441: --
2442: OPEN csr_component_exists;

Line 2513: from dual;

2509: AND retro_component_id = p_retro_component_id;
2510: --
2511: CURSOR csr_get_defn_comp_id IS
2512: SELECT pay_retro_defn_components_s.nextval
2513: from dual;
2514: --
2515: BEGIN
2516: --
2517: OPEN csr_defn_comp_exists;

Line 2587: from dual;

2583: --
2584: CURSOR csr_get_time_definition
2585: IS
2586: SELECT pay_time_definitions_s.nextval
2587: from dual;
2588: --
2589: BEGIN
2590: --
2591: OPEN csr_time_definition_exists;

Line 2670: from dual;

2666:
2667: CURSOR csr_get_time_span
2668: IS
2669: select pay_time_spans_s.nextval
2670: from dual;
2671: --
2672: BEGIN
2673: --
2674: OPEN csr_time_span_exists;

Line 2784: FROM dual;

2780: , sysdate
2781: , 1
2782: , -1
2783: , 1
2784: FROM dual;
2785: --
2786: hr_utility.trace('Inserted the required element');
2787: END IF;
2788: --

Line 2874: FROM dual;

2870: ,sysdate
2871: ,1
2872: ,-1
2873: ,1
2874: FROM dual;
2875: --
2876: SELECT pay_retro_component_usages_s.currval
2877: INTO l_retro_component_usage_id
2878: from dual;

Line 2878: from dual;

2874: FROM dual;
2875: --
2876: SELECT pay_retro_component_usages_s.currval
2877: INTO l_retro_component_usage_id
2878: from dual;
2879: --
2880: hr_utility.trace('Inserted retro component usage: ' || l_retro_component_usage_id);
2881: --
2882: create_element_spans(l_retro_component_usage_id