APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 690: SELECT resource_id FROM jtf_rs_resource_extns emp, fnd_user users WHERE

686: SELECT incident_owner_id FROM cs_incidents_all_b WHERE
687: incident_id = l_request_id;
688:
689: CURSOR sel_resource_id IS
690: SELECT resource_id FROM jtf_rs_resource_extns emp, fnd_user users WHERE
691: emp.source_id = users.employee_id and
692: users.user_id = l_user_id;
693:
694: CURSOR sel_prev_owner_id IS

Line 695: SELECT resource_id from jtf_rs_resource_extns emp WHERE

691: emp.source_id = users.employee_id and
692: users.user_id = l_user_id;
693:
694: CURSOR sel_prev_owner_id IS
695: SELECT resource_id from jtf_rs_resource_extns emp WHERE
696: source_id = l_prev_owner_id;
697:
698:
699: l_party_role_group_code cs_party_role_group_maps.party_role_group_code%TYPE;

Line 1416: SELECT resource_id FROM jtf_rs_resource_extns emp, fnd_user users WHERE

1412: l_resource_id NUMBER;
1413: l_user_id NUMBER;
1414:
1415: CURSOR sel_resource_id IS
1416: SELECT resource_id FROM jtf_rs_resource_extns emp, fnd_user users WHERE
1417: emp.source_id = users.employee_id and
1418: users.user_id = l_user_id;
1419:
1420: /* Roopa - begin

Line 1427: SELECT source_id FROM jtf_rs_resource_extns emp

1423: This cursor will get us the employee id
1424: */
1425:
1426: CURSOR l_sel_employee_id_csr IS
1427: SELECT source_id FROM jtf_rs_resource_extns emp
1428: WHERE emp.resource_id = sel_link_rec.incident_owner_id;
1429:
1430: l_employee_id NUMBER;
1431:

Line 1460: from jtf_rs_resource_extns a, fnd_user b, cs_incidents_all_b c

1456:
1457:
1458: CURSOR l_get_resource_name_csr IS
1459: SELECT source_last_name,source_first_name
1460: from jtf_rs_resource_extns a, fnd_user b, cs_incidents_all_b c
1461: WHERE c.last_updated_by = b.user_id and
1462: b.employee_id = a.source_id and
1463: c.incident_number = l_request_number;
1464:

Line 1469: from jtf_rs_resource_extns a, fnd_user b, cs_incidents_all_b c

1465: l_get_resource_name_rec l_get_resource_name_csr%ROWTYPE;
1466:
1467: CURSOR l_get_create_rsrc_csr IS
1468: SELECT source_last_name,source_first_name
1469: from jtf_rs_resource_extns a, fnd_user b, cs_incidents_all_b c
1470: WHERE c.created_by = b.user_id and
1471: b.employee_id = a.source_id and
1472: c.incident_number = l_request_number;
1473:

Line 5696: FROM jtf_rs_resource_extns emp ,

5692: l_owner_name VARCHAR2(240);
5693:
5694: CURSOR l_cs_sr_get_empid_csr IS
5695: SELECT inc.incident_number, emp.source_id
5696: FROM jtf_rs_resource_extns emp ,
5697: cs_incidents_all_b inc
5698: WHERE emp.resource_id = inc.incident_owner_id
5699: AND inc.incident_id = l_subject_id;
5700:

Line 6285: FROM jtf_rs_resource_extns emp

6281:
6282: /***
6283: CURSOR l_get_source_id IS
6284: SELECT emp.source_id
6285: FROM jtf_rs_resource_extns emp
6286: WHERE emp.resource_id = l_incident_owner_id;
6287: ***/
6288:
6289: /*** end New 03/17/03. rmanabat ***/

Line 6293: from jtf_rs_resource_extns_vl emp

6289: /*** end New 03/17/03. rmanabat ***/
6290:
6291: CURSOR l_get_source_id(p_resource_id IN NUMBER) IS
6292: select emp.source_id , emp.resource_name
6293: from jtf_rs_resource_extns_vl emp
6294: where emp.resource_id = p_resource_id;
6295: l_get_source_id_rec l_get_source_id%ROWTYPE;
6296:
6297: CURSOR l_sel_adhocrole_csr(c_role_name IN VARCHAR2) IS

Line 6877: FROM jtf_rs_resource_extns a

6873: -- Get the corresponding RESOURCE_ID, fOR the l_user_id, FROM JTF Resource schema
6874: /****
6875: SELECT a.resource_id
6876: into l_interaction_rec.resource_id
6877: FROM jtf_rs_resource_extns a
6878: WHERE a.user_id = l_user_id;
6879: ****/
6880:
6881: -- Get the resource from the profile instead. Part of fix for bug 3360069.