APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on HXC_APPROVAL_COMPS

Line 20: from hxc_approval_comps hac, hxc_app_period_summary haps

16:
17: CURSOR c_get_app_mechanism(p_app_bb_id IN NUMBER,p_app_bb_ovn IN NUMBER)
18: IS
19: select approval_mechanism
20: from hxc_approval_comps hac, hxc_app_period_summary haps
21: where haps.application_period_id = p_app_bb_id
22: and haps.application_period_ovn = p_app_bb_ovn
23: and haps.approval_comp_id = hac.approval_comp_id;
24:

Line 159: ,hxc_approval_comps hac

155: CURSOR c_timeout_enabled(p_app_bb_id in number)
156: IS
157: select hacn.notification_number_retries
158: from hxc_app_period_summary haps
159: ,hxc_approval_comps hac
160: ,hxc_app_comp_notif_usages hacnu
161: ,hxc_app_comp_notifications hacn
162: where haps.application_period_id = p_app_bb_id
163: and haps.approval_comp_id = hac.approval_comp_id

Line 174: from hxc_approval_comps hac,

170:
171: cursor c_app_comp_pm(p_bb_id number,p_bb_ovn number)
172: is
173: select hac.approval_comp_id
174: from hxc_approval_comps hac,
175: hxc_approval_styles has,
176: hxc_time_building_blocks htb
177: where htb.time_building_block_id =p_bb_id
178: and htb.object_version_number = p_bb_ovn

Line 188: from hxc_approval_comps hac

184:
185: CURSOR c_timeout_enabled_pm(p_app_comp_id in number)
186: IS
187: select hacn.notification_number_retries
188: from hxc_approval_comps hac
189: ,hxc_app_comp_notif_usages hacnu
190: ,hxc_app_comp_notifications hacn
191: where hac.approval_comp_id = p_app_comp_id
192: and hacnu.approval_comp_id = hac.approval_comp_id

Line 643: l_category_sequence hxc_approval_comps.approval_order%TYPE;

639: l_period_end_date date;
640: l_time_recipient varchar2(150);
641: l_recipient_sequence number;
642: l_time_category_id hxc_time_categories.time_category_id%TYPE;
643: l_category_sequence hxc_approval_comps.approval_order%TYPE;
644: l_approval_style_id number;
645: l_tc_url varchar2(1000);
646: l_item_key wf_items.item_key%type;
647: itemkey wf_items.item_key%type;