APPS.CUG_GENERIC_WF_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 244: select source_id from jtf_rs_resource_extns where

240: incident_id = l_request_id;
241: l_GetResourceInfo_rec l_GetResourceInfo_csr%ROWTYPE;
242:
243: CURSOR l_GetSourceId_csr IS
244: select source_id from jtf_rs_resource_extns where
245: resource_id = l_default_owner_id;
246: /* end - to fix bug # 2576759*/
247:
248:

Line 1385: SELECT source_name from JTF_RS_RESOURCE_EXTNS WHERE

1381: cta.task_type_id = l_task_type_id AND
1382: cta.incident_type_id = l_request_type_id;
1383:
1384: CURSOR c_GetResourceName_csr is
1385: SELECT source_name from JTF_RS_RESOURCE_EXTNS WHERE
1386: resource_id = l_task_owner_id;
1387: */
1388:
1389: CURSOR c_GetTaskOwnerId_csr IS

Line 1397: SELECT resource_id from JTF_RS_RESOURCE_EXTNS WHERE

1393: cta.task_type_id = l_task_type_id AND
1394: cta.incident_type_id = l_request_type_id;
1395:
1396: CURSOR c_GetResourceName_csr is
1397: SELECT resource_id from JTF_RS_RESOURCE_EXTNS WHERE
1398: resource_id = l_task_owner_id;
1399:
1400: --
1401: -- End of changes by ANEEMUCH date 23-May-2002

Line 1978: FROM cs_incidents_all_vl inc ,cs_sr_owners_v owner, jtf_rs_resource_extns emp

1974: l_API_ERROR EXCEPTION;
1975:
1976: CURSOR l_ServiceRequest_csr IS
1977: SELECT inc.customer_product_id, inc.expected_resolution_date,inc.inventory_item_id,inc.summary, emp.source_id incident_owner_id
1978: FROM cs_incidents_all_vl inc ,cs_sr_owners_v owner, jtf_rs_resource_extns emp
1979: WHERE inc.INCIDENT_OWNER_ID = owner.resource_id(+) AND
1980: emp.resource_id = owner.resource_id AND
1981: incident_id = l_request_id;
1982: