[Home] [Help]
434: IS
435: CURSOR c_attendees IS
436: SELECT source_first_name||' '||source_last_name attendee_name
437: FROM jtf_rs_resource_extns rs
438: , jtf_task_all_assignments jta
439: WHERE jta.resource_type_code = 'RS_EMPLOYEE'
440: AND jta.assignee_role = 'ASSIGNEE'
441: AND jta.task_id = p_task_id
442: AND rs.category = 'EMPLOYEE'
444: UNION
445: SELECT source_first_name||' '||source_last_name attendee_name
446: FROM jtf_rs_resource_extns rs
447: , jtf_rs_group_members rg
448: , jtf_task_all_assignments jta
449: WHERE jta.resource_type_code = 'RS_GROUP'
450: AND jta.assignee_role = 'ASSIGNEE'
451: AND jta.task_id = p_task_id
452: AND rg.group_id = jta.resource_id
454: UNION
455: SELECT source_first_name||' '||source_last_name attendee_name
456: FROM jtf_rs_resource_extns rs
457: , jtf_rs_team_members rt_ind
458: , jtf_task_all_assignments jta
459: WHERE jta.resource_type_code = 'RS_TEAM'
460: AND jta.assignee_role = 'ASSIGNEE'
461: AND jta.task_id = p_task_id
462: AND rt_ind.team_id = jta.resource_id
466: SELECT source_first_name||' '||source_last_name attendee_name
467: FROM jtf_rs_resource_extns rs
468: , jtf_rs_group_members rg
469: , jtf_rs_team_members rt_grp
470: , jtf_task_all_assignments jta
471: WHERE jta.resource_type_code = 'RS_TEAM'
472: AND jta.assignee_role = 'ASSIGNEE'
473: AND jta.task_id = p_task_id
474: AND rt_grp.team_id = jta.resource_id
596: RETURN VARCHAR2
597: IS
598: CURSOR c_assignment IS
599: SELECT assignment_status_id
600: FROM jtf_task_all_assignments
601: WHERE task_id = p_task_id
602: AND resource_type_code = 'RS_EMPLOYEE'
603: AND resource_id = p_resource_id;
604:
1418: RETURN VARCHAR2
1419: IS
1420: CURSOR c_assignment IS
1421: SELECT assignment_status_id
1422: FROM jtf_task_all_assignments
1423: WHERE task_id = p_task_id
1424: AND resource_id = p_resource_id
1425: AND resource_type_code = 'RS_EMPLOYEE';
1426: