DBA Data[Home] [Help]

APPS.CSL_WF_NOTIFICATIONS_ACC_PKG dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 20: , WF_NOTIFICATION_ATTRIBUTES wna

16: CURSOR c_notification( b_notification_id NUMBER ) IS
17: SELECT wn.RECIPIENT_ROLE
18: , wna.TEXT_VALUE
19: FROM WF_NOTIFICATIONS wn
20: , WF_NOTIFICATION_ATTRIBUTES wna
21: WHERE wn.NOTIFICATION_ID = b_notification_id
22: AND wn.MESSAGE_TYPE = 'CS_MSGS'
23: AND wn.MESSAGE_NAME = 'FYI_MESSAGE'
24: AND wn.STATUS = 'OPEN'

Line 129: , wf_notification_attributes wna

125: CURSOR c_get_sender( b_notification_id NUMBER ) IS
126: SELECT jre.resource_id
127: FROM jtf_rs_resource_extns jre
128: , fnd_user usr
129: , wf_notification_attributes wna
130: WHERE wna.name = 'SENDER'
131: AND wna.text_value = usr.user_name
132: AND usr.user_id = jre.user_id
133: AND jre.category = 'EMPLOYEE'