APPS.HXC_FIND_NOTIFY_APRS_PKG dependencies on HXC_AP_DETAIL_LINKS

Line 1382: FROM hxc_ap_detail_links apdet

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

Line 1419: from hxc_ap_detail_links adl

1415: and tau.time_Attribute_Id = ta.time_attribute_id
1416: and ta.attribute_category = 'PROJECTS'
1417: and not exists
1418: (select 1
1419: from hxc_ap_detail_links adl
1420: where adl.application_period_id = aps.application_period_id
1421: and adl.time_building_block_id = details.time_building_block_id
1422: and adl.time_building_block_ovn = details.object_version_number
1423: );

Line 1732: , hxc_ap_detail_links adl

1728: CURSOR csr_get_timecard(p_app_per_id NUMBER) IS
1729: SELECT adl.TIME_BUILDING_BLOCK_ID bb_id,
1730: adl.TIME_BUILDING_BLOCK_OVN ovn
1731: FROM hxc_time_building_blocks tbb
1732: , hxc_ap_detail_links adl
1733: WHERE adl.APPLICATION_PERIOD_ID = p_app_per_id
1734: AND
1735: tbb.time_building_block_id = adl.time_building_block_id AND
1736: tbb.object_version_number = adl.time_building_block_ovn AND

Line 2292: hxc_ap_detail_links adl

2288: cursor c_details_of_timecard( l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type )
2289: is
2290: select 'Y'
2291: from hxc_tc_ap_links tcl,
2292: hxc_ap_detail_links adl
2293: where tcl.timecard_id = l_tc_bb_id
2294: and tcl.application_period_id = adl.application_period_id
2295: and rownum < 2;
2296: