APPS.JTF_TTY_MAINTAIN_NA_PVT dependencies on JTF_RS_GRP_DENORM_VL

Line 1395: FROM jtf_rs_grp_denorm_vl grpd, jtf_tty_terr_grp_owners jto

1391:
1392: cursor get_owners_c
1393: IS
1394: SELECT jto.resource_id, jto.rsc_group_id, jto.rsc_role_code, grpd.group_id
1395: FROM jtf_rs_grp_denorm_vl grpd, jtf_tty_terr_grp_owners jto
1396: WHERE grpd.parent_group_id = JTO.rsc_group_id
1397: AND jto.terr_group_id = P_TERR_GP_ID
1398: AND grpd.group_id IN (p_group_id1, p_group_id2, p_group_id3, p_group_id4, p_group_id5,
1399: p_group_id6, p_group_id7, p_group_id8, p_group_id9, p_group_id10,

Line 1485: ' FROM jtf_rs_grp_denorm_vl grpd, jtf_tty_terr_grp_owners jto ' ||

1481: end if;
1482: END LOOP;
1483: l_get_owners :=
1484: 'SELECT jto.resource_id, jto.rsc_group_id, jto.rsc_role_code, grpd.group_id' ||
1485: ' FROM jtf_rs_grp_denorm_vl grpd, jtf_tty_terr_grp_owners jto ' ||
1486: ' WHERE grpd.parent_group_id = JTO.rsc_group_id' ||
1487: ' AND jto.terr_group_id = :P_TERR_GP_ID ' ||
1488: ' AND grpd.group_id IN (' || l_rsc_groups || ')';
1489: l_cursor := -- dbms_SQL.OPEN_CURSOR;