APPS.CN_SRP_HIER_PROC_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 1215: FROM jtf_rs_group_members jgm,

1211: ;
1212:
1213: CURSOR grp_members_csr(p_group_id NUMBER) IS
1214: SELECT DISTINCT jrs.salesrep_id salesrep_id
1215: FROM jtf_rs_group_members jgm,
1216: jtf_rs_salesreps_mo_v jrs
1217: WHERE jgm.group_id = p_group_id
1218: AND jgm.resource_id = jrs.resource_id
1219: AND nvl(jgm.delete_flag,'N') = 'N'

Line 1442: FROM jtf_rs_group_members jgm,

1438: ;
1439:
1440: CURSOR grp_members_csr(p_group_id NUMBER) IS
1441: SELECT DISTINCT jrs.salesrep_id salesrep_id
1442: FROM jtf_rs_group_members jgm,
1443: jtf_rs_salesreps_mo_v jrs
1444: WHERE jgm.group_id = p_group_id
1445: AND jgm.resource_id = jrs.resource_id
1446: AND nvl(jgm.delete_flag,'N') = 'N'