APPS.PQP_NL_PGGM_TEMPLATE dependencies on PAY_RETRO_COMPONENT_USAGES

Line 386: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;

382: l_creator_id NUMBER;
383: l_comp_name pay_retro_components.component_name%TYPE;
384: l_comp_id pay_retro_components.retro_component_id%TYPE;
385: l_comp_type pay_retro_components.retro_type%TYPE;
386: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;
387: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;
388: l_time_span_id pay_time_spans.time_span_id%TYPE;
389: l_es_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
390: l_proc_name VARCHAR2(80);

Line 461: FROM pay_retro_component_usages

457: --
458: BEGIN
459: SELECT Retro_Component_Usage_Id
460: INTO l_rc_usage_id
461: FROM pay_retro_component_usages
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

Line 466: SELECT pay_retro_component_usages_s.NEXTVAL

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

Line 474: INSERT INTO pay_retro_component_usages(

470: IF g_debug THEN
471: hr_utility.set_location('Insert Retro Comp Usgs '||l_proc_name, 20);
472: END IF;
473:
474: INSERT INTO pay_retro_component_usages(
475: RETRO_COMPONENT_USAGE_ID,
476: RETRO_COMPONENT_ID,
477: CREATOR_ID,
478: CREATOR_TYPE,

Line 2041: FROM pay_retro_component_usages

2037: -- element type id
2038: --
2039: CURSOR c_get_retro_comp_id(c_element_type_id IN NUMBER) IS
2040: SELECT retro_component_usage_id
2041: FROM pay_retro_component_usages
2042: WHERE creator_id = c_element_type_id
2043: AND creator_type = 'ET'
2044: AND business_group_id = p_business_group_id;
2045: