APPS.JTF_TTY_NA_WF dependencies on JTF_TTY_NAMED_ACCTS

Line 90: from JTF_TTY_NAMED_ACCTS NA

86: l_named_account_rec NA_Rec_Type;
87:
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

Line 210: ' FROM JTF_TTY_NAMED_ACCTS TNA '||

206: ' when (QM_1007.VALUE1_CHAR BETWEEN 20100 AND 20200) AND (NVL(QM_1007.VALUE2_CHAR,20100) BETWEEN 20100 AND 20200) then ''VA'' '||
207: ' when (QM_1007.VALUE1_CHAR BETWEEN 22000 AND 24699) AND (NVL(QM_1007.VALUE2_CHAR,22000) BETWEEN 22000 AND 24699) then ''VA'' end '||
208: ' CALCULATED_STATE '||
209: ' , QM_1012.VALUE1_CHAR CUSTOMER_NAME '||
210: ' FROM JTF_TTY_NAMED_ACCTS TNA '||
211: ' , JTF_TTY_ACCT_QUAL_MAPS QM_1007 '||
212: ' , JTF_TTY_ACCT_QUAL_MAPS QM_1012 '||
213: ' WHERE '||
214: ' TNA.NAMED_ACCOUNT_ID = QM_1007.NAMED_ACCOUNT_ID '||

Line 310: from jtf_tty_named_accts

306: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('begin add_org_to_terrgp');
307:
308: select count(*)
309: into p_account_count
310: from jtf_tty_named_accts
311: where party_id = p_party_id;
312:
313: if p_account_count = 1 then
314: select named_account_id

Line 316: from jtf_tty_named_accts

312:
313: if p_account_count = 1 then
314: select named_account_id
315: into x_account_id
316: from jtf_tty_named_accts
317: where party_id = p_party_id;
318: else
319: -- create a new named account for the party, if one does not exist
320: select JTF_TTY_NAMED_ACCTS_S.nextval

Line 320: select JTF_TTY_NAMED_ACCTS_S.nextval

316: from jtf_tty_named_accts
317: where party_id = p_party_id;
318: else
319: -- create a new named account for the party, if one does not exist
320: select JTF_TTY_NAMED_ACCTS_S.nextval
321: into x_account_id
322: from dual;
323: end if;
324:

Line 330: insert into jtf_tty_named_accts

326:
327: if (p_account_count < 1) then
328: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('create a named account');
329:
330: insert into jtf_tty_named_accts
331: (NAMED_ACCOUNT_ID,
332: OBJECT_VERSION_NUMBER ,
333: PARTY_ID ,
334: MAPPING_COMPLETE_FLAG,