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_TIME_SPANS

Line 316: l_time_span_id pay_time_spans.time_span_id%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;
318: l_proc_name VARCHAR2(80);
319: --
320: --

Line 446: pay_time_spans ts

442: SELECT ts.time_span_id
443: INTO l_time_span_id
444: FROM pay_time_definitions s,
445: pay_time_definitions e,
446: pay_time_spans ts
447: WHERE ts.creator_id = l_comp_id
448: AND ts.creator_type = 'RC'
449: AND ts.start_time_def_id = s.time_definition_id
450: AND ts.end_time_def_id = e.time_definition_id