APPS.CCT_JTFRESOURCEROUTING_PUB dependencies on JTF_RS_GROUPS_B

Line 389: from jtf_rs_groups_b a,

385: select resource_id
386: from jtf_rs_group_members
387: where delete_flag='N'
388: and group_id = ( select a.group_id
389: from jtf_rs_groups_b a,
390: jtf_rs_group_usages b
391: where a.group_number = p_group_number
392: and b.usage='CALL'
393: and b.group_ID=a.group_ID