DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIMECARD dependencies on HXC_APP_COMP_NOTIFICATIONS_API

Line 4298: and wna.text_value = hxc_app_comp_notifications_api.c_action_request_approval

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

Line 4300: and wnb.text_value = hxc_app_comp_notifications_api.c_recipient_supervisor;

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: