4294: wf_notification_attributes wnb
4295: where wna.notification_id = wnb.notification_id
4296: and wna.notification_id = p_notif_id
4297: and wna.name = 'FYI_ACTION_CODE'
4298: and wna.text_value = hxc_app_comp_notifications_api.c_action_request_approval
4299: and wnb.name ='FYI_RECIPIENT_CODE'
4300: and wnb.text_value = hxc_app_comp_notifications_api.c_recipient_supervisor;
4301:
4302: BEGIN
4296: and wna.notification_id = p_notif_id
4297: and wna.name = 'FYI_ACTION_CODE'
4298: and wna.text_value = hxc_app_comp_notifications_api.c_action_request_approval
4299: and wnb.name ='FYI_RECIPIENT_CODE'
4300: and wnb.text_value = hxc_app_comp_notifications_api.c_recipient_supervisor;
4301:
4302: BEGIN
4303:
4304: