APPS.HXC_FIND_NOTIFY_APRS_PKG dependencies on HXC_APP_PERIOD_SUMMARY

Line 306: (p_application_period_id in hxc_app_period_summary.application_period_id%type)

302: -- Internal Development Use Only.
303: --
304: -- {End Of Comments}
305: function get_description
306: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
307: return varchar2 is
308:
309: l_description fnd_new_messages.message_text%type;
310: begin

Line 432: from hxc_app_period_summary

428: CURSOR c_get_item_key(
429: p_app_bb_id IN NUMBER )
430: IS
431: select approval_item_key
432: from hxc_app_period_summary
433: where application_period_id = p_app_bb_id;
434:
435: l_item_key varchar2(240);
436: l_old_style_flag BOOLEAN;

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 758: FROM hxc_app_period_summary apsum

754: SELECT apc.approval_mechanism,
755: apc.approval_mechanism_id,
756: apc.wf_item_type,
757: apc.wf_name
758: FROM hxc_app_period_summary apsum
759: ,hxc_approval_comps apc
760: WHERE apsum.application_period_id = p_ap_bb_id
761: AND apsum.application_period_ovn = p_ap_bb_ovn
762: AND apsum.approval_comp_id = apc.approval_comp_id

Line 784: (p_application_period_id in hxc_app_period_summary.application_period_id%type

780:
781:
782:
783: cursor c_approval_comp_alt
784: (p_application_period_id in hxc_app_period_summary.application_period_id%type
785: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type) is
786: SELECT apc.approval_mechanism,
787: apc.approval_mechanism_id,
788: apc.wf_item_type,

Line 785: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type) is

781:
782:
783: cursor c_approval_comp_alt
784: (p_application_period_id in hxc_app_period_summary.application_period_id%type
785: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type) is
786: SELECT apc.approval_mechanism,
787: apc.approval_mechanism_id,
788: apc.wf_item_type,
789: apc.wf_name

Line 790: FROM hxc_app_period_summary apsum

786: SELECT apc.approval_mechanism,
787: apc.approval_mechanism_id,
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

Line 1400: hxc_app_period_summary aps,

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
1404: and aps.stop_time >= days.start_time

Line 2300: FROM hxc_app_period_summary

2296:
2297: cursor c_find_app_per_id( l_ap_bb_id in hxc_time_building_blocks.time_building_block_id%type)
2298: is
2299: SELECT 'Y'
2300: FROM hxc_app_period_summary
2301: WHERE time_category_id = 0
2302: AND APPLICATION_PERIOD_ID = l_ap_bb_id
2303: AND approval_comp_id = (SELECT approval_comp_id
2304: FROM hxc_approval_comps

Line 2323: from hxc_app_period_summary

2319:
2320: cursor c_appr_comp(p_app_bb_id number,p_app_bb_ovn number)
2321: is
2322: select approval_comp_id
2323: from hxc_app_period_summary
2324: where application_period_id = p_app_bb_id
2325: and application_period_ovn = p_app_bb_ovn;
2326:
2327: