APPS.PQP_NL_ABP_TEMPLATE dependencies on PAY_RETRO_COMPONENT_USAGES

Line 306: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;

302: l_creator_id number;
303: l_comp_name pay_retro_components.component_name%TYPE;
304: l_comp_id pay_retro_components.retro_component_id%TYPE;
305: l_comp_type pay_retro_components.retro_type%TYPE;
306: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;
307: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;
308: l_time_span_id pay_time_spans.time_span_id%TYPE;
309: l_es_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
310: begin

Line 369: from pay_retro_component_usages

365: --
366: begin
367: select Retro_Component_Usage_Id
368: into l_rc_usage_id
369: from pay_retro_component_usages
370: where retro_component_id = l_comp_id
371: and creator_id = l_creator_id
372: and creator_type = p_creator_type;
373: exception when no_data_found then

Line 374: select pay_retro_component_usages_s.nextval

370: where retro_component_id = l_comp_id
371: and creator_id = l_creator_id
372: and creator_type = p_creator_type;
373: exception when no_data_found then
374: select pay_retro_component_usages_s.nextval
375: into l_rc_usage_id
376: from dual;
377: --
378:

Line 379: insert into pay_retro_component_usages(

375: into l_rc_usage_id
376: from dual;
377: --
378:
379: insert into pay_retro_component_usages(
380: RETRO_COMPONENT_USAGE_ID,
381: RETRO_COMPONENT_ID,
382: CREATOR_ID,
383: CREATOR_TYPE,

Line 2079: FROM pay_retro_component_usages

2075:
2076: --cursor to fetch the retro component usage id for a given element type id
2077: CURSOR c_get_retro_comp_id(c_element_type_id in number) IS
2078: SELECT retro_component_usage_id
2079: FROM pay_retro_component_usages
2080: WHERE creator_id = c_element_type_id
2081: AND creator_type = 'ET'
2082: AND business_group_id = p_business_group_id;
2083:

Line 2191: FROM pay_retro_component_usages

2187: WHERE element_span_usage_id = temp_rec.element_span_usage_id;
2188: END LOOP;
2189: --finally delete the retro component usage
2190: DELETE
2191: FROM pay_retro_component_usages
2192: WHERE retro_component_usage_id = l_retro_comp_id;
2193: ELSE
2194: CLOSE c_get_retro_comp_id;
2195: END IF;

Line 2213: FROM pay_retro_component_usages

2209: WHERE element_span_usage_id = temp_rec.element_span_usage_id;
2210: END LOOP;
2211: --finally delete the retro component usage
2212: DELETE
2213: FROM pay_retro_component_usages
2214: WHERE retro_component_usage_id = l_retro_comp_id;
2215: ELSE
2216: CLOSE c_get_retro_comp_id;
2217: END IF;