APPS.PAY_AU_RETRO_UPGRADE dependencies on DUAL

Line 1507: from dual;

1503: IF c_retro_comp_exists%NOTFOUND THEN
1504:
1505: select pay_retro_component_usages_s.nextval
1506: into ln_retro_component_usage_id
1507: from dual;
1508:
1509: insert into pay_retro_component_usages
1510: (retro_component_usage_id, retro_component_id, creator_id, creator_type,
1511: default_component, reprocess_type, business_group_id, legislation_code,

Line 2643: FROM dual;

2639: --
2640: CURSOR csr_get_defn_id
2641: IS
2642: SELECT pay_retro_definitions_s.nextval
2643: FROM dual;
2644: --
2645: BEGIN
2646: --
2647: OPEN csr_defn_exists;

Line 2707: FROM dual;

2703: --
2704: CURSOR csr_get_comp_id
2705: IS
2706: SELECT pay_retro_components_s.nextval
2707: FROM dual;
2708: --
2709: BEGIN
2710: --
2711: OPEN csr_component_exists;

Line 2782: from dual;

2778: AND retro_component_id = p_retro_component_id;
2779: --
2780: CURSOR csr_get_defn_comp_id IS
2781: SELECT pay_retro_defn_components_s.nextval
2782: from dual;
2783: --
2784: BEGIN
2785: --
2786: OPEN csr_defn_comp_exists;

Line 2856: from dual;

2852: --
2853: CURSOR csr_get_time_definition
2854: IS
2855: SELECT pay_time_definitions_s.nextval
2856: from dual;
2857: --
2858: BEGIN
2859: --
2860: OPEN csr_time_definition_exists;

Line 2939: from dual;

2935:
2936: CURSOR csr_get_time_span
2937: IS
2938: select pay_time_spans_s.nextval
2939: from dual;
2940: --
2941: BEGIN
2942: --
2943: OPEN csr_time_span_exists;

Line 3053: FROM dual;

3049: , sysdate
3050: , 1
3051: , -1
3052: , 1
3053: FROM dual;
3054: --
3055: hr_utility.trace('Inserted the required element');
3056: END IF;
3057: --

Line 3143: FROM dual;

3139: ,sysdate
3140: ,1
3141: ,-1
3142: ,1
3143: FROM dual;
3144: --
3145: SELECT pay_retro_component_usages_s.currval
3146: INTO l_retro_component_usage_id
3147: from dual;

Line 3147: from dual;

3143: FROM dual;
3144: --
3145: SELECT pay_retro_component_usages_s.currval
3146: INTO l_retro_component_usage_id
3147: from dual;
3148: --
3149: hr_utility.trace('Inserted retro component usage: ' || l_retro_component_usage_id);
3150: --
3151: create_element_spans(l_retro_component_usage_id