APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_RETRO_COMPONENT_USAGES_S

Line 1505: select pay_retro_component_usages_s.nextval

1501: OPEN c_retro_comp_exists;
1502: FETCH c_retro_comp_exists INTO ln_retro_component_usage_id;
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

Line 3130: pay_retro_component_usages_s.nextval

3126: ,LAST_UPDATED_BY
3127: ,LAST_UPDATE_LOGIN
3128: ,OBJECT_VERSION_NUMBER)
3129: SELECT
3130: pay_retro_component_usages_s.nextval
3131: ,l_retro_component_id
3132: ,l_element_type_id
3133: ,'ET'
3134: ,p_default_component

Line 3145: SELECT pay_retro_component_usages_s.currval

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