831: jtf_tasks_tl ctl,
832: cs_incidents_all_b cia,
833: hz_parties hzp,
834: jtf_task_statuses_b jts,
835: jtf_task_statuses_tl jtstl
836: WHERE res.user_id IN '|| l_user_lst || '
837: AND a.resource_id = res.resource_id
838: AND a.resource_type_code = ''RS_EMPLOYEE''
839: AND ct.task_id = a.task_id
873: jtf_tasks_tl ctl,
874: cs_incidents_all_b cia,
875: hz_parties hzp,
876: jtf_task_statuses_b jts,
877: jtf_task_statuses_tl jtstl,
878: jtf_rs_groups_tl gtl
879: WHERE a.resource_type_code = ''RS_GROUP''
880: AND a.resource_id IN ' || l_group_lst ||'
881: AND ct.task_id = a.task_id
1448: jtf_task_priorities_tl tptl,
1449: jtf_task_types_b ttb,
1450: jtf_task_types_tl tttl,
1451: jtf_task_statuses_b ts,
1452: jtf_task_statuses_tl tstl,
1453: cs_incidents_all_b csb,
1454: cs_incidents_all_tl cstl,
1455: hz_parties hzp,
1456: hz_party_sites hzps,