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_PGGM_TEMPLATE dependencies on PAY_RETRO_COMPONENTS

Line 383: l_comp_name pay_retro_components.component_name%TYPE;

379: p_end_time_def_name VARCHAR2 DEFAULT 'End of Time',
380: p_business_group_id NUMBER)
381: IS
382: l_creator_id NUMBER;
383: l_comp_name pay_retro_components.component_name%TYPE;
384: l_comp_id pay_retro_components.retro_component_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;

Line 384: l_comp_id pay_retro_components.retro_component_id%TYPE;

380: p_business_group_id NUMBER)
381: IS
382: l_creator_id NUMBER;
383: l_comp_name pay_retro_components.component_name%TYPE;
384: l_comp_id pay_retro_components.retro_component_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;

Line 385: l_comp_type pay_retro_components.retro_type%TYPE;

381: IS
382: l_creator_id NUMBER;
383: l_comp_name pay_retro_components.component_name%TYPE;
384: l_comp_id pay_retro_components.retro_component_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;

Line 441: pay_retro_components rc

437: SELECT rc.retro_component_id,rc.component_name, rc.retro_type
438: INTO l_comp_id, l_comp_name, l_comp_type
439: FROM pay_retro_definitions rd,
440: pay_retro_defn_components rdc,
441: pay_retro_components rc
442: WHERE rdc.retro_component_id = rc.retro_component_id
443: AND rc.legislation_code = g_legislation_code
444: AND rdc.priority = p_retro_component_priority
445: AND rd.retro_definition_id = rdc.retro_definition_id