APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_RETRO_COMPONENT_USAGES

Line 1284: FROM pay_retro_component_usages

1280:
1281: CURSOR c_retro_comp_exists
1282: is
1283: SELECT retro_component_usage_id
1284: FROM pay_retro_component_usages
1285: WHERE creator_id = p_creator_id
1286: AND p_business_group_id = business_group_id
1287: AND retro_component_id = p_retro_component_id;
1288:

Line 1302: select pay_retro_component_usages_s.nextval

1298: OPEN c_retro_comp_exists;
1299: FETCH c_retro_comp_exists INTO ln_retro_component_usage_id;
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

Line 1306: insert into pay_retro_component_usages

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,
1309: creation_date, created_by, last_update_date, last_updated_by,
1310: last_update_login, object_version_number)

Line 1830: from pay_retro_component_usages prcu,

1826: /* Checks whether retro component exist for the element */
1827: CURSOR c_get_retro_components
1828: IS
1829: select count(*)
1830: from pay_retro_component_usages prcu,
1831: pay_retro_components prc
1832: where prc.legislation_code = 'AU'
1833: and prc.retro_component_id = prcu.retro_component_id
1834: AND prcu.creator_id = p_element_type_id

Line 2721: (p_retro_component_usage_id IN pay_retro_component_usages.retro_component_usage_id%TYPE

2717: -- If the creator_id and creator_type combination already exists
2718: -- then the details will not be updated.
2719: --------------------------------------------------------------------------
2720: PROCEDURE create_element_spans
2721: (p_retro_component_usage_id IN pay_retro_component_usages.retro_component_usage_id%TYPE
2722: ,p_retro_component_id IN pay_retro_components.retro_component_id%TYPE
2723: ,p_retro_element_name IN pay_element_types_f.element_name%TYPE
2724: ,p_time_span_id IN pay_element_span_usages.time_span_id%TYPE
2725: )

Line 2805: l_retro_component_usage_id pay_retro_component_usages.retro_component_usage_id%TYPE;

2801: ,p_time_span_id IN pay_element_span_usages.time_span_id%TYPE
2802: )
2803: IS
2804: --
2805: l_retro_component_usage_id pay_retro_component_usages.retro_component_usage_id%TYPE;
2806: l_retro_component_id pay_retro_components.retro_component_id%TYPE;
2807: l_element_type_id pay_element_types_f.element_type_id%TYPE;
2808: --
2809: CURSOR csr_get_details IS

Line 2821: FROM pay_retro_component_usages prcu

2817: AND c.legislation_code = g_legislation_code;
2818: --
2819: CURSOR csr_exists IS
2820: SELECT retro_component_usage_id
2821: FROM pay_retro_component_usages prcu
2822: WHERE prcu.retro_component_id = l_retro_component_id
2823: AND prcu.creator_id = l_element_type_id
2824: AND prcu.creator_type ='ET';
2825: --

Line 2846: INSERT INTO pay_retro_component_usages

2842: IF l_retro_component_usage_id is null THEN
2843: --
2844: hr_utility.trace('Before inserting data into component usages');
2845: --
2846: INSERT INTO pay_retro_component_usages
2847: (RETRO_COMPONENT_USAGE_ID
2848: ,RETRO_COMPONENT_ID
2849: ,CREATOR_ID
2850: ,CREATOR_TYPE

Line 2861: pay_retro_component_usages_s.nextval

2857: ,LAST_UPDATED_BY
2858: ,LAST_UPDATE_LOGIN
2859: ,OBJECT_VERSION_NUMBER)
2860: SELECT
2861: pay_retro_component_usages_s.nextval
2862: ,l_retro_component_id
2863: ,l_element_type_id
2864: ,'ET'
2865: ,p_default_component

Line 2876: SELECT pay_retro_component_usages_s.currval

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;
2879: --
2880: hr_utility.trace('Inserted retro component usage: ' || l_retro_component_usage_id);