APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on HXC_APPROVAL_COMPS

Line 71: from hxc_approval_comps hac, hxc_app_period_summary haps

67:
68: CURSOR c_get_app_mechanism(p_app_bb_id IN NUMBER,p_app_bb_ovn IN NUMBER)
69: IS
70: select approval_mechanism
71: from hxc_approval_comps hac, hxc_app_period_summary haps
72: where haps.application_period_id = p_app_bb_id
73: and haps.application_period_ovn = p_app_bb_ovn
74: and haps.approval_comp_id = hac.approval_comp_id;
75:

Line 210: ,hxc_approval_comps hac

206: CURSOR c_timeout_enabled(p_app_bb_id in number)
207: IS
208: select hacn.notification_number_retries
209: from hxc_app_period_summary haps
210: ,hxc_approval_comps hac
211: ,hxc_app_comp_notif_usages hacnu
212: ,hxc_app_comp_notifications hacn
213: where haps.application_period_id = p_app_bb_id
214: and haps.approval_comp_id = hac.approval_comp_id

Line 225: from hxc_approval_comps hac,

221:
222: cursor c_app_comp_pm(p_bb_id number,p_bb_ovn number)
223: is
224: select hac.approval_comp_id
225: from hxc_approval_comps hac,
226: hxc_approval_styles has,
227: hxc_time_building_blocks htb
228: where htb.time_building_block_id =p_bb_id
229: and htb.object_version_number = p_bb_ovn

Line 239: from hxc_approval_comps hac

235:
236: CURSOR c_timeout_enabled_pm(p_app_comp_id in number)
237: IS
238: select hacn.notification_number_retries
239: from hxc_approval_comps hac
240: ,hxc_app_comp_notif_usages hacnu
241: ,hxc_app_comp_notifications hacn
242: where hac.approval_comp_id = p_app_comp_id
243: and hacnu.approval_comp_id = hac.approval_comp_id

Line 694: l_category_sequence hxc_approval_comps.approval_order%TYPE;

690: l_period_end_date date;
691: l_time_recipient varchar2(150);
692: l_recipient_sequence number;
693: l_time_category_id hxc_time_categories.time_category_id%TYPE;
694: l_category_sequence hxc_approval_comps.approval_order%TYPE;
695: l_approval_style_id number;
696: l_tc_url varchar2(1000);
697: l_item_key wf_items.item_key%type;
698: itemkey wf_items.item_key%type;