DBA Data[Home] [Help]

APPS.PAY_RETRO_PKG dependencies on PAY_ELEMENT_SPAN_USAGES

Line 491: from pay_element_span_usages pesu,

487: where business_group_id = p_business_group_id;
488: --
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

Line 535: from pay_element_span_usages pesu,

531: for a Standard Retro Element
532: */
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