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 1420: SELECT resource_id FROM jtf_rs_resource_extns emp, fnd_user users WHERE

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

Line 1431: SELECT source_id FROM jtf_rs_resource_extns emp

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

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

1460:
1461:
1462: CURSOR l_get_resource_name_csr IS
1463: SELECT source_last_name,source_first_name
1464: from jtf_rs_resource_extns a, fnd_user b, cs_incidents_all_b c
1465: WHERE c.last_updated_by = b.user_id and
1466: b.employee_id = a.source_id and
1467: c.incident_number = l_request_number;
1468:

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

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

Line 5760: FROM jtf_rs_resource_extns emp ,

5756: l_owner_name VARCHAR2(240);
5757:
5758: CURSOR l_cs_sr_get_empid_csr IS
5759: SELECT inc.incident_number, emp.source_id
5760: FROM jtf_rs_resource_extns emp ,
5761: cs_incidents_all_b inc
5762: WHERE emp.resource_id = inc.incident_owner_id
5763: AND inc.incident_id = l_subject_id;
5764:

Line 6349: FROM jtf_rs_resource_extns emp

6345:
6346: /***
6347: CURSOR l_get_source_id IS
6348: SELECT emp.source_id
6349: FROM jtf_rs_resource_extns emp
6350: WHERE emp.resource_id = l_incident_owner_id;
6351: ***/
6352:
6353: /*** end New 03/17/03. rmanabat ***/

Line 6357: from jtf_rs_resource_extns_vl emp

6353: /*** end New 03/17/03. rmanabat ***/
6354:
6355: CURSOR l_get_source_id(p_resource_id IN NUMBER) IS
6356: select emp.source_id , emp.resource_name
6357: from jtf_rs_resource_extns_vl emp
6358: where emp.resource_id = p_resource_id;
6359: l_get_source_id_rec l_get_source_id%ROWTYPE;
6360:
6361: CURSOR l_sel_adhocrole_csr(c_role_name IN VARCHAR2) IS

Line 6941: FROM jtf_rs_resource_extns a

6937: -- Get the corresponding RESOURCE_ID, fOR the l_user_id, FROM JTF Resource schema
6938: /****
6939: SELECT a.resource_id
6940: into l_interaction_rec.resource_id
6941: FROM jtf_rs_resource_extns a
6942: WHERE a.user_id = l_user_id;
6943: ****/
6944:
6945: -- Get the resource from the profile instead. Part of fix for bug 3360069.