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_ATTRIBUTE_USAGES

Line 29: HXC_TIME_ATTRIBUTE_USAGES tau,

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
33: and tau.time_building_block_id =

Line 1351: ,hxc_time_attribute_usages htau

1347: IS
1348: SELECT hta.attribute1
1349: FROM hxc_ap_detail_links apdet
1350: ,hxc_time_building_blocks htbb
1351: ,hxc_time_attribute_usages htau
1352: ,hxc_time_attributes hta
1353: WHERE apdet.application_period_id = p_ap_bb_id
1354: AND apdet.time_building_block_id = htbb.time_building_block_id
1355: AND htbb.date_to = hr_general.end_of_time

Line 1366: hxc_time_attribute_usages tau,

1362: (p_app_bb_id in hxc_time_building_blocks.time_building_block_id%type) is
1363: select to_number(ta.attribute1)
1364: from hxc_time_building_blocks details,
1365: hxc_time_building_blocks days,
1366: hxc_time_attribute_usages tau,
1367: hxc_app_period_summary aps,
1368: hxc_time_Attributes ta
1369: where aps.application_period_id = p_app_bb_id
1370: and aps.start_time <= days.stop_time