APPS.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on PAY_RETRO_COMPONENT_USAGES

Line 314: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;

310: l_creator_id NUMBER;
311: l_comp_name pay_retro_components.component_name%TYPE;
312: l_comp_id pay_retro_components.retro_component_id%TYPE;
313: l_comp_type pay_retro_components.retro_type%TYPE;
314: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;
315: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;
316: l_time_span_id pay_time_spans.time_span_id%TYPE;
317: l_es_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
318: l_proc_name VARCHAR2(80);

Line 389: FROM pay_retro_component_usages

385: --
386: BEGIN
387: SELECT Retro_Component_Usage_Id
388: INTO l_rc_usage_id
389: FROM pay_retro_component_usages
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

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

Line 402: INSERT INTO pay_retro_component_usages(

398: IF g_debug THEN
399: hr_utility.set_location('Insert Retro Comp Usgs '||l_proc_name, 20);
400: END IF;
401:
402: INSERT INTO pay_retro_component_usages(
403: RETRO_COMPONENT_USAGE_ID,
404: RETRO_COMPONENT_ID,
405: CREATOR_ID,
406: CREATOR_TYPE,