APPS.AS_LEAD_ROUTING_WF_CUHK dependencies on JTF_RS_RESOURCE_EXTNS

Line 139: FROM jtf_rs_resource_extns res

135: -- may not have person_id for all resources. Therefore, get person_id
136: -- is this cursor.
137: CURSOR c_get_person_id(c_resource_id NUMBER) IS
138: SELECT res.source_id
139: FROM jtf_rs_resource_extns res
140: WHERE res.resource_id = c_resource_id;
141:
142: CURSOR C_Get_Lead_Info(C_Sales_Lead_Id NUMBER) IS
143: SELECT SL.CUSTOMER_ID, SL.ADDRESS_ID