APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_RETRO_COMPONENT_USAGES_S

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 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);