DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIMECARD dependencies on HXC_APP_COMP_NOTIFICATIONS_API

Line 4634: and wna.text_value = hxc_app_comp_notifications_api.c_action_request_approval

4630: wf_notification_attributes wnb
4631: where wna.notification_id = wnb.notification_id
4632: and wna.notification_id = p_notif_id
4633: and wna.name = 'FYI_ACTION_CODE'
4634: and wna.text_value = hxc_app_comp_notifications_api.c_action_request_approval
4635: and wnb.name ='FYI_RECIPIENT_CODE'
4636: and wnb.text_value = hxc_app_comp_notifications_api.c_recipient_supervisor;
4637:
4638: BEGIN

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

4632: and wna.notification_id = p_notif_id
4633: and wna.name = 'FYI_ACTION_CODE'
4634: and wna.text_value = hxc_app_comp_notifications_api.c_action_request_approval
4635: and wnb.name ='FYI_RECIPIENT_CODE'
4636: and wnb.text_value = hxc_app_comp_notifications_api.c_recipient_supervisor;
4637:
4638: BEGIN
4639:
4640: