APPS.PQP_NL_ABP_TEMPLATE dependencies on PAY_ELEMENT_SPAN_USAGES

Line 309: l_es_usage_id pay_element_span_usages.element_span_usage_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
311: if g_creator.name = p_creator_name
312: and g_creator.type = p_creator_type
313: then

Line 438: from pay_element_span_usages

434: --
435: begin
436: select element_span_usage_id
437: into l_es_usage_id
438: from pay_element_span_usages
439: where time_span_id = l_time_span_id
440: and retro_component_usage_id = l_rc_usage_id
441: and adjustment_type is null;
442: exception when no_data_found then

Line 443: select pay_element_span_usages_s.nextval

439: where time_span_id = l_time_span_id
440: and retro_component_usage_id = l_rc_usage_id
441: and adjustment_type is null;
442: exception when no_data_found then
443: select pay_element_span_usages_s.nextval
444: into l_es_usage_id
445: from dual;
446:
447:

Line 449: insert into pay_element_span_usages(

445: from dual;
446:
447:
448:
449: insert into pay_element_span_usages(
450: ELEMENT_SPAN_USAGE_ID,
451: BUSINESS_GROUP_ID,
452: LEGISLATION_CODE,
453: TIME_SPAN_ID,

Line 2087: FROM pay_element_span_usages

2083:
2084: --cursor to fetch the element span usage ids for the element type id
2085: CURSOR c_get_element_span_id(c_retro_comp_usage_id in number) IS
2086: SELECT element_span_usage_id
2087: FROM pay_element_span_usages
2088: WHERE retro_component_usage_id = c_retro_comp_usage_id
2089: AND business_group_id = p_business_group_id;
2090:
2091:

Line 2186: FROM pay_element_span_usages

2182: => l_retro_comp_id
2183: )
2184: LOOP
2185: DELETE
2186: FROM pay_element_span_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

Line 2208: FROM pay_element_span_usages

2204: => l_retro_comp_id
2205: )
2206: LOOP
2207: DELETE
2208: FROM pay_element_span_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