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