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 766: (p_application_period_id in hxc_app_period_summary.application_period_id%type

762: AND apsum.approval_comp_id = apc.approval_comp_id;
763:
764:
765: cursor c_approval_comp_alt
766: (p_application_period_id in hxc_app_period_summary.application_period_id%type
767: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type) is
768: SELECT apc.approval_mechanism,
769: apc.approval_mechanism_id,
770: apc.wf_item_type,

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

763:
764:
765: cursor c_approval_comp_alt
766: (p_application_period_id in hxc_app_period_summary.application_period_id%type
767: ,p_application_period_ovn in hxc_app_period_summary.application_period_ovn%type) is
768: SELECT apc.approval_mechanism,
769: apc.approval_mechanism_id,
770: apc.wf_item_type,
771: apc.wf_name

Line 772: FROM hxc_app_period_summary apsum

768: SELECT apc.approval_mechanism,
769: apc.approval_mechanism_id,
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

Line 1367: hxc_app_period_summary aps,

1363: select to_number(ta.attribute1)
1364: from hxc_time_building_blocks details,
1365: hxc_time_building_blocks days,
1366: hxc_time_attribute_usages tau,
1367: hxc_app_period_summary aps,
1368: hxc_time_Attributes ta
1369: where aps.application_period_id = p_app_bb_id
1370: and aps.start_time <= days.stop_time
1371: and aps.stop_time >= days.start_time

Line 2159: FROM hxc_app_period_summary

2155:
2156: cursor c_find_app_per_id( l_ap_bb_id in hxc_time_building_blocks.time_building_block_id%type)
2157: is
2158: SELECT 'Y'
2159: FROM hxc_app_period_summary
2160: WHERE time_category_id = 0
2161: AND APPLICATION_PERIOD_ID = l_ap_bb_id
2162: AND approval_comp_id = (SELECT approval_comp_id
2163: FROM hxc_approval_comps

Line 2182: from hxc_app_period_summary

2178:
2179: cursor c_appr_comp(p_app_bb_id number,p_app_bb_ovn number)
2180: is
2181: select approval_comp_id
2182: from hxc_app_period_summary
2183: where application_period_id = p_app_bb_id
2184: and application_period_ovn = p_app_bb_ovn;
2185:
2186: