APPS.CCT_JTFRESOURCEROUTING_PUB dependencies on JTF_RS_GROUP_USAGES_VL

Line 89: jtf_rs_group_usages_vl b

85: FROM jtf_rs_group_members
86: WHERE delete_flag='N'
87: AND group_id = ( SELECT distinct a.group_id
88: FROM jtf_rs_groups_vl a,
89: jtf_rs_group_usages_vl b
90: WHERE b.usage='CALL'
91: AND b.group_ID=a.group_ID
92: AND a.start_date_active<=sysdate
93: AND nvl(a.end_date_active,sysdate)>=sysdate

Line 138: jtf_rs_group_usages_vl b

134: FROM jtf_rs_group_members
135: WHERE delete_flag='N'
136: AND group_id= ( SELECT a.group_id
137: FROM jtf_rs_groups_vl a,
138: jtf_rs_group_usages_vl b
139: WHERE b.usage='CALL'
140: AND b.group_ID=a.group_ID
141: AND a.start_date_active<=sysdate
142: AND nvl(a.end_date_active,sysdate)>=sysdate

Line 334: -- jtf_rs_group_usages_vl b

330: -- FROM jtf_rs_group_members
331: -- WHERE delete_flag='N'
332: -- AND group_id= ( SELECT distinct a.group_id
333: -- FROM jtf_rs_groups_vl a,
334: -- jtf_rs_group_usages_vl b
335: -- WHERE b.usage='CALL'
336: -- AND b.group_ID=a.group_ID
337: -- AND a.start_date_active<=sysdate
338: -- AND nvl(a.end_date_active,sysdate)>=sysdate

Line 412: -- jtf_rs_group_usages_vl b

408: -- FROM jtf_rs_group_members
409: -- WHERE delete_flag='N'
410: -- AND group_id = ( SELECT a.group_id
411: -- FROM jtf_rs_groups_vl a,
412: -- jtf_rs_group_usages_vl b
413: -- WHERE b.usage='CALL'
414: -- AND b.group_ID=a.group_ID
415: -- AND a.start_date_active<=sysdate
416: -- AND nvl(a.end_date_active,sysdate)>=sysdate