APPS.JTF_TTY_NA_TERRGP dependencies on JTF_TTY_NAMED_ACCT_RSC_S

Line 929: ( SELECT jtf_tty_named_acct_rsc_s.NEXTVAL,

925: CREATED_BY,
926: CREATION_DATE,
927: LAST_UPDATED_BY,
928: LAST_UPDATE_DATE)
929: ( SELECT jtf_tty_named_acct_rsc_s.NEXTVAL,
930: 1,
931: terrgrpid_nodup(i),
932: RplOwnerToRsc(idx),
933: RplOwnerToGrp(idx),

Line 982: ( SELECT jtf_tty_named_acct_rsc_s.nextval,

978: CREATED_BY,
979: CREATION_DATE,
980: LAST_UPDATED_BY,
981: LAST_UPDATE_DATE)
982: ( SELECT jtf_tty_named_acct_rsc_s.nextval,
983: 1,
984: tgaHasParent.tga_id,
985: owner.resource_id,
986: owner.rsc_group_id,

Line 1039: ( SELECT jtf_tty_named_acct_rsc_s.nextval,

1035: CREATED_BY,
1036: CREATION_DATE,
1037: LAST_UPDATED_BY,
1038: LAST_UPDATE_DATE)
1039: ( SELECT jtf_tty_named_acct_rsc_s.nextval,
1040: 1,
1041: tgaNoParent.tga_id,
1042: owner.resource_id,
1043: owner.rsc_group_id,

Line 1361: (SELECT jtf_tty_named_acct_rsc_s.NEXTVAL,

1357: CREATED_BY,
1358: CREATION_DATE,
1359: LAST_UPDATED_BY,
1360: LAST_UPDATE_DATE)
1361: (SELECT jtf_tty_named_acct_rsc_s.NEXTVAL,
1362: 1,
1363: p_terr_gp_acct_id,
1364: p_resource_id,
1365: p_group_id,

Line 1461: (SELECT jtf_tty_named_acct_rsc_s.NEXTVAL,

1457: CREATED_BY,
1458: CREATION_DATE,
1459: LAST_UPDATED_BY,
1460: LAST_UPDATE_DATE)
1461: (SELECT jtf_tty_named_acct_rsc_s.NEXTVAL,
1462: 1,
1463: a.TERR_GROUP_ACCOUNT_ID,
1464: p_resource_id,
1465: p_group_id,

Line 3163: SELECT jtf_tty_named_acct_rsc_s.NEXTVAL

3159: );
3160: END IF;
3161: -- assign resource to the named account
3162:
3163: SELECT jtf_tty_named_acct_rsc_s.NEXTVAL
3164: INTO p_terr_gp_acct_rsc_id
3165: FROM dual;
3166:
3167: INSERT INTO jtf_tty_named_acct_rsc