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 1480: hxc_app_period_summary aps

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

Line 1487: hxc_app_period_summary aps2

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