DBA Data[Home] [Help]

APPS.CSM_EMAIL_QUERY_PKG dependencies on JTF_TASK_STATUSES_TL

Line 835: jtf_task_statuses_tl jtstl

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

Line 877: jtf_task_statuses_tl jtstl,

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

Line 1452: jtf_task_statuses_tl tstl,

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,