DBA Data[Home] [Help]

APPS.PAY_RETRO_PKG dependencies on PAY_TIME_SPANS

Line 493: pay_time_spans pts

489: select pesu.retro_element_type_id
490: into l_retro_ele_type_id
491: from pay_element_span_usages pesu,
492: pay_retro_component_usages prcu,
493: pay_time_spans pts
494: where prcu.retro_component_id = p_retro_comp_id
495: and prcu.creator_id = p_element_type_id
496: and prcu.creator_type = 'ET'
497: and prcu.retro_component_usage_id = pesu.retro_component_usage_id

Line 537: pay_time_spans pts

533: select pesu.retro_element_type_id
534: into l_retro_ele_type_id
535: from pay_element_span_usages pesu,
536: pay_retro_component_usages prcu,
537: pay_time_spans pts
538: where prcu.retro_component_id = p_retro_comp_id
539: and prcu.creator_id = p_element_type_id
540: and prcu.creator_type = 'ET'
541: and prcu.retro_component_usage_id = pesu.retro_component_usage_id