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.PQP_NL_ABP_TEMPLATE dependencies on PAY_RETRO_COMPONENTS

Line 303: l_comp_name pay_retro_components.component_name%TYPE;

299: p_end_time_def_name varchar2 default 'End of Time',
300: p_business_group_id number)
301: is
302: l_creator_id number;
303: l_comp_name pay_retro_components.component_name%TYPE;
304: l_comp_id pay_retro_components.retro_component_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;

Line 304: l_comp_id pay_retro_components.retro_component_id%TYPE;

300: p_business_group_id number)
301: is
302: l_creator_id number;
303: l_comp_name pay_retro_components.component_name%TYPE;
304: l_comp_id pay_retro_components.retro_component_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;

Line 305: l_comp_type pay_retro_components.retro_type%TYPE;

301: is
302: l_creator_id number;
303: l_comp_name pay_retro_components.component_name%TYPE;
304: l_comp_id pay_retro_components.retro_component_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;

Line 349: pay_retro_components rc

345: select rc.retro_component_id,rc.component_name, rc.retro_type
346: into l_comp_id, l_comp_name, l_comp_type
347: from pay_retro_definitions rd,
348: pay_retro_defn_components rdc,
349: pay_retro_components rc
350: where rdc.retro_component_id = rc.retro_component_id
351: and rc.legislation_code = g_legislation_code
352: and rdc.priority = p_retro_component_priority
353: and rd.retro_definition_id = rdc.retro_definition_id