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_DEPOSIT_CHECKS dependencies on HXC_APP_PERIOD_SUMMARY

Line 1483: hxc_app_period_summary aps

1479: (p_detail_id in hxc_ap_detail_links.time_building_block_id%type,
1480: p_detail_ovn in hxc_ap_detail_links.time_building_block_ovn%type) is
1481: select 'Y'
1482: from hxc_ap_detail_links adl,
1483: hxc_app_period_summary aps
1484: where adl.time_building_block_id = p_detail_id
1485: and adl.time_building_block_ovn = p_detail_ovn
1486: and adl.application_period_id = aps.application_period_id
1487: and aps.approval_status = hxc_timecard.c_approved_status

Line 1490: hxc_app_period_summary aps2

1486: and adl.application_period_id = aps.application_period_id
1487: and aps.approval_status = hxc_timecard.c_approved_status
1488: and not exists(select 1
1489: from hxc_ap_detail_links adl2,
1490: hxc_app_period_summary aps2
1491: where adl2.time_building_block_id = adl.time_building_block_id
1492: and adl2.time_building_block_ovn = adl.time_building_block_ovn
1493: and adl2.application_period_id <> adl.application_period_id
1494: and adl2.application_period_id = aps2.application_period_id