DBA Data[Home] [Help]

APPS.OKL_REQ_WF dependencies on JTF_RS_RESOURCE_EXTNS

Line 156: FROM JTF_RS_RESOURCE_EXTNS a,

152:
153: CURSOR notif_mgr_csr(a_trans_id NUMBER)
154: IS
155: SELECT b.user_name
156: FROM JTF_RS_RESOURCE_EXTNS a,
157: JTF_RS_RESOURCE_EXTNS b
158: WHERE b.source_id = a.source_mgr_id
159: AND a.user_id
160: IN

Line 157: JTF_RS_RESOURCE_EXTNS b

153: CURSOR notif_mgr_csr(a_trans_id NUMBER)
154: IS
155: SELECT b.user_name
156: FROM JTF_RS_RESOURCE_EXTNS a,
157: JTF_RS_RESOURCE_EXTNS b
158: WHERE b.source_id = a.source_mgr_id
159: AND a.user_id
160: IN
161: (SELECT created_by