APPS.JTF_TTY_NA_WF dependencies on JTF_TTY_NAMED_ACCT_RSC

Line 92: , JTF_TTY_NAMED_ACCT_RSC NAR

88: CURSOR c_resources(c_named_account_id NUMBER, c_terr_group_id NUMBER) IS
89: select NAR.RSC_GROUP_ID, NAR.RESOURCE_ID, RLV.ROLE_ID, NAR.RSC_ROLE_CODE
90: from JTF_TTY_NAMED_ACCTS NA
91: , JTF_TTY_TERR_GRP_ACCTS TGA
92: , JTF_TTY_NAMED_ACCT_RSC NAR
93: , JTF_RS_ROLES_VL RLV
94: where NA.NAMED_ACCOUNT_ID = TGA.NAMED_ACCOUNT_ID
95: AND TGA.TERR_GROUP_ACCOUNT_ID = NAR.TERR_GROUP_ACCOUNT_ID
96: AND RLV.ROLE_CODE = NAR.RSC_ROLE_CODE

Line 245: --create record in JTF_TTY_NAMED_ACCOUNT, JTF_TTY_ACCT_QUAL_MAPS, JTF_TTY_NAMED_ACCT_RSC

241: LOOP
242: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('rs_rec.rsc_group_id is:'||rs_rec.rsc_group_id);
243: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('rs_rec.resource_id is:'||rs_rec.resource_id);
244:
245: --create record in JTF_TTY_NAMED_ACCOUNT, JTF_TTY_ACCT_QUAL_MAPS, JTF_TTY_NAMED_ACCT_RSC
246: --so that NA territory is created next time
247:
248: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('calling add_org_to_terrgp');
249: /** creates a NA, if one for this party_id does not already exist else

Line 392: select jtf_tty_named_acct_rsc_s.nextval

388: );
389:
390: -- assign resource to the named account
391:
392: select jtf_tty_named_acct_rsc_s.nextval
393: into p_terr_gp_acct_rsc_id
394: from dual;
395:
396: insert into jtf_tty_named_acct_rsc

Line 396: insert into jtf_tty_named_acct_rsc

392: select jtf_tty_named_acct_rsc_s.nextval
393: into p_terr_gp_acct_rsc_id
394: from dual;
395:
396: insert into jtf_tty_named_acct_rsc
397: (ACCOUNT_RESOURCE_ID,
398: OBJECT_VERSION_NUMBER ,
399: TERR_GROUP_ACCOUNT_ID,
400: RESOURCE_ID ,