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_FIND_NOTIFY_APRS_PKG dependencies on HXC_TIME_ATTRIBUTES

Line 28: FROM HXC_TIME_ATTRIBUTES ta,

24: SELECT apbb.resource_id,
25: apbb.start_time,
26: apbb.stop_time,
27: ta.attribute1 recipient_app
28: FROM HXC_TIME_ATTRIBUTES ta,
29: HXC_TIME_ATTRIBUTE_USAGES tau,
30: HXC_TIME_BUILDING_BLOCKS apbb
31: WHERE apbb.time_building_block_id = b_ap_bbid
32: and apbb.object_version_number = b_ap_bbovn

Line 1385: ,hxc_time_attributes hta

1381: SELECT hta.attribute1
1382: FROM hxc_ap_detail_links apdet
1383: ,hxc_time_building_blocks htbb
1384: ,hxc_time_attribute_usages htau
1385: ,hxc_time_attributes hta
1386: WHERE apdet.application_period_id = p_ap_bb_id
1387: AND apdet.time_building_block_id = htbb.time_building_block_id
1388: AND htbb.date_to = hr_general.end_of_time
1389: AND htbb.time_building_block_id = htau.time_building_block_id

Line 1401: hxc_time_Attributes ta

1397: from hxc_time_building_blocks details,
1398: hxc_time_building_blocks days,
1399: hxc_time_attribute_usages tau,
1400: hxc_app_period_summary aps,
1401: hxc_time_Attributes ta
1402: where aps.application_period_id = p_app_bb_id
1403: and aps.start_time <= days.stop_time
1404: and aps.stop_time >= days.start_time
1405: and aps.resource_id = days.resource_Id