APPS.HXC_FIND_NOTIFY_APRS_PKG dependencies on HXC_TC_AP_LINKS

Line 625: FROM hxc_tc_ap_links tcl, hxc_app_period_summary aps

621: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE
622: )
623: IS
624: SELECT aps.application_period_id
625: FROM hxc_tc_ap_links tcl, hxc_app_period_summary aps
626: WHERE tcl.timecard_id = p_timecard_id
627: AND tcl.application_period_id = aps.application_period_id
628: AND aps.notification_status = 'NOTIFIED';
629:

Line 774: ,hxc_tc_ap_links tcl

770: apc.wf_item_type,
771: apc.wf_name
772: FROM hxc_app_period_summary apsum
773: ,hxc_approval_comps apc
774: ,hxc_tc_ap_links tcl
775: ,hxc_time_building_blocks tbb
776: WHERE apsum.application_period_id = p_application_period_id
777: AND apsum.application_period_ovn = p_application_period_ovn
778: and apsum.application_period_id = tcl.application_period_id

Line 1606: FROM hxc_tc_ap_links htl,

1602:
1603: /* Bug fix for 5526281 */
1604: CURSOR get_timecard_start_date(p_app_per_id NUMBER) IS
1605: SELECT tbb.start_time ,tbb.stop_time
1606: FROM hxc_tc_ap_links htl,
1607: hxc_time_building_blocks tbb
1608: WHERE htl.application_period_id = p_app_per_id
1609: AND tbb.time_building_block_id = htl.timecard_id;
1610:

Line 2150: from hxc_tc_ap_links tcl,

2146:
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;