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 1384: ,hxc_time_attribute_usages htau

1380: IS
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

Line 1399: hxc_time_attribute_usages tau,

1395: (p_app_bb_id in hxc_time_building_blocks.time_building_block_id%type) is
1396: select to_number(ta.attribute1)
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