APPS.PQP_NL_SAVINGS_TEMPLATE dependencies on PAY_RETRO_COMPONENTS

Line 23: l_comp_name pay_retro_components.component_name%TYPE;

19: p_end_time_def_name VARCHAR2 DEFAULT 'End of Time',
20: p_business_group_id NUMBER)
21: IS
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;

Line 24: l_comp_id pay_retro_components.retro_component_id%TYPE;

20: p_business_group_id NUMBER)
21: IS
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;

Line 25: l_comp_type pay_retro_components.retro_type%TYPE;

21: IS
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;

Line 81: pay_retro_components rc

77: SELECT rc.retro_component_id,rc.component_name, rc.retro_type
78: INTO l_comp_id, l_comp_name, l_comp_type
79: FROM pay_retro_definitions rd,
80: pay_retro_defn_components rdc,
81: pay_retro_components rc
82: WHERE rdc.retro_component_id = rc.retro_component_id
83: AND rc.legislation_code = g_legislation_code
84: AND rdc.priority = p_retro_component_priority
85: AND rd.retro_definition_id = rdc.retro_definition_id