DBA Data[Home] [Help]

APPS.HXC_SELF_SERVICE_TIMECARD dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 4293: from wf_notification_attributes wna,

4289:
4290: CURSOR c_is_sup_notification(p_notif_id in wf_notifications.notification_id%TYPE)
4291: is
4292: select 'Y'
4293: from wf_notification_attributes wna,
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'

Line 4294: wf_notification_attributes wnb

4290: CURSOR c_is_sup_notification(p_notif_id in wf_notifications.notification_id%TYPE)
4291: is
4292: select 'Y'
4293: from wf_notification_attributes wna,
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