DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIMECARD dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 4629: from wf_notification_attributes wna,

4625:
4626: CURSOR c_is_sup_notification(p_notif_id in wf_notifications.notification_id%TYPE)
4627: is
4628: select 'Y'
4629: from wf_notification_attributes wna,
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'

Line 4630: wf_notification_attributes wnb

4626: CURSOR c_is_sup_notification(p_notif_id in wf_notifications.notification_id%TYPE)
4627: is
4628: select 'Y'
4629: from wf_notification_attributes wna,
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