APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on PAY_RETRO_COMPONENT_USAGES

Line 26: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;

22: l_creator_id NUMBER;
23: l_comp_name pay_retro_components.component_name%TYPE;
24: l_comp_id pay_retro_components.retro_component_id%TYPE;
25: l_comp_type pay_retro_components.retro_type%TYPE;
26: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;
27: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;
28: l_time_span_id pay_time_spans.time_span_id%TYPE;
29: l_es_usage_id pay_element_span_usages.element_span_usage_id%TYPE;
30: l_proc_name VARCHAR2(80);

Line 101: FROM pay_retro_component_usages

97: --
98: BEGIN
99: SELECT Retro_Component_Usage_Id
100: INTO l_rc_usage_id
101: FROM pay_retro_component_usages
102: WHERE retro_component_id = l_comp_id
103: AND creator_id = l_creator_id
104: AND creator_type = p_creator_type;
105: EXCEPTION WHEN no_data_found THEN

Line 106: SELECT pay_retro_component_usages_s.NEXTVAL

102: WHERE retro_component_id = l_comp_id
103: AND creator_id = l_creator_id
104: AND creator_type = p_creator_type;
105: EXCEPTION WHEN no_data_found THEN
106: SELECT pay_retro_component_usages_s.NEXTVAL
107: INTO l_rc_usage_id
108: FROM dual;
109: --
110: IF g_debug THEN

Line 114: INSERT INTO pay_retro_component_usages(

110: IF g_debug THEN
111: hr_utility.set_location('Insert Retro Comp Usgs '||l_proc_name, 20);
112: END IF;
113:
114: INSERT INTO pay_retro_component_usages(
115: RETRO_COMPONENT_USAGE_ID,
116: RETRO_COMPONENT_ID,
117: CREATOR_ID,
118: CREATOR_TYPE,