APPS.PV_PG_NOTIF_UTILITY_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 195: -- JTF_RS_RESOURCE_EXTNS table for a given resource_id

191: -- get_requestor_details
192: --
193: -- PURPOSE
194: -- This procedure will return enrollment requestor details from
195: -- JTF_RS_RESOURCE_EXTNS table for a given resource_id
196: -- Called By
197: -- NOTES
198: -- End of Comments
199: =============================================================================*/

Line 211: FROM JTF_RS_RESOURCE_EXTNS

207: IS
208: /* Get the Requestor details in cursor c_reqestor_details */
209: CURSOR c_requestor_details(cv_req_resource_id IN NUMBER) IS
210: SELECT user_id, source_name, user_name
211: FROM JTF_RS_RESOURCE_EXTNS
212: WHERE resource_id = cv_req_resource_id;
213:
214: BEGIN
215: /* Initialize API return status to success */

Line 536: FROM JTF_RS_RESOURCE_EXTNS_VL

532: l_error_msg VARCHAR2(4000);
533:
534: CURSOR c_resource IS
535: SELECT source_id, user_id, category
536: FROM JTF_RS_RESOURCE_EXTNS_VL
537: WHERE resource_id > 0
538: AND ( category = 'EMPLOYEE'
539: OR category = 'PARTNER'
540: OR category = 'PARTY')