APPS.CS_ROUTING_UTL dependencies on CS_GROUP_LEVEL_ASSIGNS

Line 328: -- CS_GROUP_LEVEL_ASSIGNS table given a service request type.

324: ------------------------------------------------------------------------------
325: -- Function : Get_Employees_From_SR_Type
326: -- Usage : Used by the Routing module to get the employee list
327: -- Description : This function retrieves the employee list from the
328: -- CS_GROUP_LEVEL_ASSIGNS table given a service request type.
329: -- Parameters :
330: -- p_incident_number IN NUMBER Required
331: -- x_emp_tbl OUT emp_tbl_type
332: --

Line 345: v_current_id cs_group_level_assigns.role_person_id%type;

341: x_emp_tbl OUT emp_tbl_type)
342: RETURN NUMBER IS
343:
344: v_total_num_of_emps NUMBER:=0;
345: v_current_id cs_group_level_assigns.role_person_id%type;
346: v_incident_type_id cs_incidents_all.incident_type_id%type;
347:
348: --
349: -- get service request type given an incident ID

Line 361: FROM cs_group_level_assigns cgla

357: -- get a list of employees that is responsible to a service request type
358: --
359: CURSOR c_employees IS
360: SELECT DISTINCT cgla.role_person_id
361: FROM cs_group_level_assigns cgla
362: WHERE (cgla.sr_type_id = v_incident_type_id AND
363: cgla.role_person_orig_system = 'PER')
364: UNION
365: SELECT DISTINCT paf.person_id

Line 366: FROM cs_group_level_assigns cgla,

362: WHERE (cgla.sr_type_id = v_incident_type_id AND
363: cgla.role_person_orig_system = 'PER')
364: UNION
365: SELECT DISTINCT paf.person_id
366: FROM cs_group_level_assigns cgla,
367: per_assignments_f paf
368: WHERE (cgla.sr_type_id = v_incident_type_id AND
369: cgla.role_person_orig_system = 'POS' AND
370: paf.position_id = cgla.role_person_id);