DBA Data[Home] [Help]

APPS.CSL_WF_NOTIFICATIONS_ACC_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 32: FROM JTF_RS_RESOURCE_EXTNS jre

28: r_notification c_notification%ROWTYPE;
29:
30: CURSOR c_mobile( b_user_name VARCHAR2 ) IS
31: SELECT jre.RESOURCE_ID
32: FROM JTF_RS_RESOURCE_EXTNS jre
33: , FND_USER usr
34: WHERE usr.USER_NAME = b_user_name
35: AND usr.user_id = jre.user_id;
36:

Line 115: FROM jtf_rs_resource_extns jre

111: )
112: IS
113: SELECT jre.resource_id
114: , usr.user_id
115: FROM jtf_rs_resource_extns jre
116: , fnd_user usr
117: , wf_notifications wfn
118: WHERE wfn.recipient_role = usr.user_name
119: AND usr.user_id = jre.user_id

Line 127: FROM jtf_rs_resource_extns jre

123: r_get_recipient c_get_recipient%ROWTYPE;
124:
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