DBA Data[Home] [Help]

APPS.PQP_NL_PGGM_TEMPLATE dependencies on PAY_TIME_SPANS

Line 388: l_time_span_id pay_time_spans.time_span_id%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;
390: l_proc_name VARCHAR2(80);
391: --
392: --

Line 518: pay_time_spans ts

514: SELECT ts.time_span_id
515: INTO l_time_span_id
516: FROM pay_time_definitions s,
517: pay_time_definitions e,
518: pay_time_spans ts
519: WHERE ts.creator_id = l_comp_id
520: AND ts.creator_type = 'RC'
521: AND ts.start_time_def_id = s.time_definition_id
522: AND ts.end_time_def_id = e.time_definition_id