APPS.PQP_NL_PGGM_TEMPLATE dependencies on PAY_ELEMENT_SPAN_USAGES

Line 389: l_es_usage_id pay_element_span_usages.element_span_usage_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);
391: --
392: --
393: --

Line 544: FROM pay_element_span_usages

540: --
541: BEGIN
542: SELECT element_span_usage_id
543: INTO l_es_usage_id
544: FROM pay_element_span_usages
545: WHERE time_span_id = l_time_span_id
546: AND retro_component_usage_id = l_rc_usage_id
547: AND adjustment_type IS NULL;
548:

Line 550: SELECT pay_element_span_usages_s.NEXTVAL

546: AND retro_component_usage_id = l_rc_usage_id
547: AND adjustment_type IS NULL;
548:
549: EXCEPTION WHEN no_data_found THEN
550: SELECT pay_element_span_usages_s.NEXTVAL
551: INTO l_es_usage_id
552: FROM dual;
553:
554: IF g_debug THEN

Line 558: INSERT INTO pay_element_span_usages(

554: IF g_debug THEN
555: hr_utility.set_location('Insert Element Span Usgs '||l_proc_name, 30);
556: END IF;
557:
558: INSERT INTO pay_element_span_usages(
559: ELEMENT_SPAN_USAGE_ID,
560: BUSINESS_GROUP_ID,
561: LEGISLATION_CODE,
562: TIME_SPAN_ID,

Line 2051: FROM pay_element_span_usages

2047: -- Cursor to fetch the element span usage ids for the element type id
2048: --
2049: CURSOR c_get_element_span_id(c_retro_comp_usage_id IN NUMBER) IS
2050: SELECT element_span_usage_id
2051: FROM pay_element_span_usages
2052: WHERE retro_component_usage_id = c_retro_comp_usage_id
2053: AND business_group_id = p_business_group_id;
2054:
2055: CURSOR c_er_ele (c_base_name IN VARCHAR2) IS