eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_LIFE_SAVINGS_TEMPLATE dependencies on PAY_RETRO_COMPONENTS

Line 311: l_comp_name pay_retro_components.component_name%TYPE;

307: p_end_time_def_name VARCHAR2 DEFAULT 'End of Time',
308: p_business_group_id NUMBER)
309: IS
310: l_creator_id NUMBER;
311: l_comp_name pay_retro_components.component_name%TYPE;
312: l_comp_id pay_retro_components.retro_component_id%TYPE;
313: l_comp_type pay_retro_components.retro_type%TYPE;
314: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;
315: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;

Line 312: l_comp_id pay_retro_components.retro_component_id%TYPE;

308: p_business_group_id NUMBER)
309: IS
310: l_creator_id NUMBER;
311: l_comp_name pay_retro_components.component_name%TYPE;
312: l_comp_id pay_retro_components.retro_component_id%TYPE;
313: l_comp_type pay_retro_components.retro_type%TYPE;
314: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;
315: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;
316: l_time_span_id pay_time_spans.time_span_id%TYPE;

Line 313: l_comp_type pay_retro_components.retro_type%TYPE;

309: IS
310: l_creator_id NUMBER;
311: l_comp_name pay_retro_components.component_name%TYPE;
312: l_comp_id pay_retro_components.retro_component_id%TYPE;
313: l_comp_type pay_retro_components.retro_type%TYPE;
314: l_rc_usage_id pay_retro_component_usages.Retro_Component_Usage_Id%TYPE;
315: l_retro_ele_id pay_element_types_f.element_type_id%TYPE;
316: l_time_span_id pay_time_spans.time_span_id%TYPE;
317: l_es_usage_id pay_element_span_usages.element_span_usage_id%TYPE;

Line 369: pay_retro_components rc

365: SELECT rc.retro_component_id,rc.component_name, rc.retro_type
366: INTO l_comp_id, l_comp_name, l_comp_type
367: FROM pay_retro_definitions rd,
368: pay_retro_defn_components rdc,
369: pay_retro_components rc
370: WHERE rdc.retro_component_id = rc.retro_component_id
371: AND rc.legislation_code = g_legislation_code
372: AND rdc.priority = p_retro_component_priority
373: AND rd.retro_definition_id = rdc.retro_definition_id