DBA Data[Home] [Help]

APPS.CSM_EMAIL_QUERY_PKG dependencies on JTF_RS_GROUPS_TL

Line 585: jtf_rs_groups_tl gtl,

581: SELECT gb.group_id,
582: gtl.group_name
583: FROM jtf_rs_resource_extns rs,
584: jtf_rs_groups_b gb,
585: jtf_rs_groups_tl gtl,
586: jtf_rs_group_members gm,
587: jtf_rs_roles_b rb,
588: jtf_rs_role_relations rr_grp,
589: jtf_rs_role_relations rr_res

Line 878: jtf_rs_groups_tl gtl

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
882: AND ct.open_flag = ''Y''