APPS.JTF_TTY_MAINTAIN_NA_PVT dependencies on JTF_TTY_TERR_GRP_OWNERS

Line 944: FROM jtf_tty_terr_grp_owners

940:
941: -- Cursor to get resource details for TG owner(s) : Multiple Rows
942: CURSOR c_get_rsc_details(l_tg_id NUMBER) IS
943: SELECT rsc_group_id, resource_id, rsc_role_code, rsc_resource_type
944: FROM jtf_tty_terr_grp_owners
945: WHERE terr_group_id = l_tg_id;
946:
947: BEGIN
948:

Line 1293: jtf_tty_terr_grp_owners jto,

1289: admin is doing upload, he/she is doing as the owner of the TG */
1290: SELECT 'VALID'
1291: INTO l_select
1292: FROM jtf_tty_srch_my_resources_v /*jtf_tty_my_resources_v*/ grv,
1293: jtf_tty_terr_grp_owners jto,
1294: jtf_rs_resource_extns res
1295: WHERE EXISTS
1296: ( SELECT NULL
1297: FROM jtf_rs_groups_denorm grpd

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;

Line 1557: from jtf_tty_terr_grp_owners

1553: cursor getTerrgpOwners(id IN NUMBER) is
1554: select resource_id,
1555: rsc_group_id,
1556: rsc_role_code
1557: from jtf_tty_terr_grp_owners
1558: where terr_group_id = id;
1559:
1560: p_owner_user_rsc_id NUMBER;
1561: p_owner_group_id NUMBER;

Line 2427: from jtf_tty_terr_grp_owners

2423: select resource_id,
2424: rsc_group_id,
2425: rsc_role_code,
2426: 'N' delete_flag
2427: from jtf_tty_terr_grp_owners
2428: where terr_group_id = l_tg_id;
2429:
2430:
2431: BEGIN

Line 2756: from jtf_tty_terr_grp_owners

2752: select resource_id,
2753: rsc_group_id,
2754: rsc_role_code,
2755: 'N' delete_flag
2756: from jtf_tty_terr_grp_owners
2757: where terr_group_id = l_tg_id;
2758:
2759:
2760: BEGIN