DBA Data[Home] [Help]

APPS.PAY_RETRO_PKG dependencies on PAY_TIME_SPANS

Line 513: pay_time_spans pts

509: select pesu.retro_element_type_id
510: into l_retro_ele_type_id
511: from pay_element_span_usages pesu,
512: pay_retro_component_usages prcu,
513: pay_time_spans pts
514: where prcu.retro_component_id = p_retro_comp_id
515: and prcu.creator_id = p_element_type_id
516: and prcu.creator_type = 'ET'
517: and prcu.retro_component_usage_id = pesu.retro_component_usage_id

Line 557: pay_time_spans pts

553: select pesu.retro_element_type_id
554: into l_retro_ele_type_id
555: from pay_element_span_usages pesu,
556: pay_retro_component_usages prcu,
557: pay_time_spans pts
558: where prcu.retro_component_id = p_retro_comp_id
559: and prcu.creator_id = p_element_type_id
560: and prcu.creator_type = 'ET'
561: and prcu.retro_component_usage_id = pesu.retro_component_usage_id