DBA Data[Home] [Help]

APPS.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on PAY_RETRO_COMPONENT_USAGES_S

Line 394: SELECT pay_retro_component_usages_s.NEXTVAL

390: WHERE retro_component_id = l_comp_id
391: AND creator_id = l_creator_id
392: AND creator_type = p_creator_type;
393: EXCEPTION WHEN no_data_found THEN
394: SELECT pay_retro_component_usages_s.NEXTVAL
395: INTO l_rc_usage_id
396: FROM dual;
397: --
398: IF g_debug THEN