APPS.HXC_FIND_NOTIFY_APRS_PKG dependencies on HXC_AP_DETAIL_LINKS

Line 1349: FROM hxc_ap_detail_links apdet

1345: p_ap_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
1346: )
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

Line 1386: from hxc_ap_detail_links adl

1382: and tau.time_Attribute_Id = ta.time_attribute_id
1383: and ta.attribute_category = 'PROJECTS'
1384: and not exists
1385: (select 1
1386: from hxc_ap_detail_links adl
1387: where adl.application_period_id = aps.application_period_id
1388: and adl.time_building_block_id = details.time_building_block_id
1389: and adl.time_building_block_ovn = details.object_version_number
1390: );

Line 1591: , hxc_ap_detail_links adl

1587: CURSOR csr_get_timecard(p_app_per_id NUMBER) IS
1588: SELECT adl.TIME_BUILDING_BLOCK_ID bb_id,
1589: adl.TIME_BUILDING_BLOCK_OVN ovn
1590: FROM hxc_time_building_blocks tbb
1591: , hxc_ap_detail_links adl
1592: WHERE adl.APPLICATION_PERIOD_ID = p_app_per_id
1593: AND
1594: tbb.time_building_block_id = adl.time_building_block_id AND
1595: tbb.object_version_number = adl.time_building_block_ovn AND

Line 2151: hxc_ap_detail_links adl

2147: cursor c_details_of_timecard( l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type )
2148: is
2149: select 'Y'
2150: from hxc_tc_ap_links tcl,
2151: hxc_ap_detail_links adl
2152: where tcl.timecard_id = l_tc_bb_id
2153: and tcl.application_period_id = adl.application_period_id
2154: and rownum < 2;
2155: