eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_APPROVAL_WF_HELPER dependencies on HXC_AP_DETAIL_LINKS

Line 759: from hxc_ap_detail_links adl

755: CURSOR c_get_detail_blocks(p_application_period_id in hxc_time_building_blocks.time_building_block_id%type)
756: is
757: select adl.time_building_block_id,
758: adl.time_building_block_ovn
759: from hxc_ap_detail_links adl
760: where adl.application_period_id = p_application_period_id;
761:
762:
763: CURSOR c_get_notifications(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type

Line 804: from hxc_ap_detail_links a,

800: CURSOR c_chk_auto_approve(p_app_bb_id in number)
801: is
802:
803: select d.approval_mechanism
804: from hxc_ap_detail_links a,
805: hxc_latest_details b,
806: hxc_app_period_summary c,
807: hxc_approval_comps d
808: where a.time_building_block_id in (select time_building_block_id

Line 809: from hxc_ap_detail_links

805: hxc_latest_details b,
806: hxc_app_period_summary c,
807: hxc_approval_comps d
808: where a.time_building_block_id in (select time_building_block_id
809: from hxc_ap_detail_links
810: where application_period_id =p_app_period_id)
811: and a.application_period_id <>p_app_period_id
812: and b.time_building_block_id = a.time_building_block_id
813: and b.object_version_number = a.time_building_block_ovn