[Home] [Help]
462: WHERE retro_component_id = l_comp_id
463: AND creator_id = l_creator_id
464: AND creator_type = p_creator_type;
465: EXCEPTION WHEN no_data_found THEN
466: SELECT pay_retro_component_usages_s.NEXTVAL
467: INTO l_rc_usage_id
468: FROM dual;
469: --
470: IF g_debug THEN