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 792: ,hxc_tc_ap_links tcl

788: apc.wf_item_type,
789: apc.wf_name
790: FROM hxc_app_period_summary apsum
791: ,hxc_approval_comps apc
792: ,hxc_tc_ap_links tcl
793: ,hxc_time_building_blocks tbb
794: WHERE apsum.application_period_id = p_application_period_id
795: AND apsum.application_period_ovn = p_application_period_ovn
796: and apsum.application_period_id = tcl.application_period_id

Line 1747: FROM hxc_tc_ap_links htl,

1743:
1744: /* Bug fix for 5526281 */
1745: CURSOR get_timecard_start_date(p_app_per_id NUMBER) IS
1746: SELECT tbb.start_time ,tbb.stop_time
1747: FROM hxc_tc_ap_links htl,
1748: hxc_time_building_blocks tbb
1749: WHERE htl.application_period_id = p_app_per_id
1750: AND tbb.time_building_block_id = htl.timecard_id;
1751:

Line 2291: from hxc_tc_ap_links tcl,

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