DBA Data[Home] [Help]

APPS.HXC_INLINE_NOTIF_UTILS_PKG dependencies on HXC_AP_DETAIL_LINKS

Line 593: from hxc_time_building_blocks htbb, hxc_ap_detail_links hadl

589:
590: cursor get_last_creation_dates(p_app_bb_id NUMBER) is
591: select tab.creation_date
592: from (select distinct htbb.creation_date creation_date
593: from hxc_time_building_blocks htbb, hxc_ap_detail_links hadl
594: where htbb.time_building_block_id = hadl.time_building_block_id
595: and hadl.application_period_id = p_app_bb_id
596: order by creation_date desc) tab
597: where rownum <= 2;