DBA Data[Home] [Help]

APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on HXC_APP_COMP_NOTIF_USAGES

Line 211: ,hxc_app_comp_notif_usages hacnu

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
215: and hacnu.approval_comp_id = hac.approval_comp_id

Line 240: ,hxc_app_comp_notif_usages hacnu

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
244: and hacnu.approval_comp_ovn = hac.object_version_number