APPS.CSM_EMAIL_QUERY_PKG dependencies on JTF_TASK_STATUSES_B

Line 834: jtf_task_statuses_b jts,

830: jtf_tasks_b ct,
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''

Line 876: jtf_task_statuses_b jts,

872: jtf_tasks_b ct,
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 ||'

Line 1235: FROM jtf_task_statuses_b tsb

1231: AS
1232: CURSOR c_task_status
1233: IS
1234: SELECT tsb.task_status_id
1235: FROM jtf_task_statuses_b tsb
1236: WHERE tsb.COMPLETED_FLAG = 'Y'
1237: AND tsb.USAGE ='TASK'
1238: AND tsb.SEEDED_FLAG = 'Y'
1239: AND tsb.CLOSED_FLAG IS NULL

Line 1451: jtf_task_statuses_b ts,

1447: jtf_task_priorities_b tpb,
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,