APPS.JTF_TTY_NA_WF dependencies on JTF_TTY_TERR_GRP_ACCTS

Line 21: -- 02/25/03 ARPATEL Added DN_MAPPING_COMPLETE_FLAG='N' when creating record in JTF_TTY_TERR_GRP_ACCTS

17: -- This package is for PRIVATE USE ONLY use
18: --
19: -- HISTORY
20: -- 12/13/02 ARPATEL Package Body Created
21: -- 02/25/03 ARPATEL Added DN_MAPPING_COMPLETE_FLAG='N' when creating record in JTF_TTY_TERR_GRP_ACCTS
22: -- 04/25/03 ARPATEL bug#2878006 fix
23: -- 06/02/03 ARPATEL bug#2987314 fix
24: -- End of Comments
25: --

Line 91: , JTF_TTY_TERR_GRP_ACCTS TGA

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
95: AND TGA.TERR_GROUP_ACCOUNT_ID = NAR.TERR_GROUP_ACCOUNT_ID

Line 218: ' )ILV , JTF_TTY_TERR_GRP_ACCTS TGA '||

214: ' TNA.NAMED_ACCOUNT_ID = QM_1007.NAMED_ACCOUNT_ID '||
215: ' AND QM_1007.QUAL_USG_ID = -1007 '||
216: ' AND QM_1007.NAMED_ACCOUNT_ID = QM_1012.NAMED_ACCOUNT_ID '||
217: ' AND QM_1012.QUAL_USG_ID = -1012 '||
218: ' )ILV , JTF_TTY_TERR_GRP_ACCTS TGA '||
219: ' WHERE ILV.NAMED_ACCOUNT_ID = TGA.NAMED_ACCOUNT_ID '||
220: ' AND ILV.CALCULATED_STATE = '''||l_lead_state||
221: ''' AND ( ILV.CUSTOMER_NAME = '''||l_lead_keyword || ''' OR ''' || l_lead_keyword || ''' LIKE ILV.CUSTOMER_NAME )'||
222: ' AND rownum < 2 '||

Line 354: select JTF_TTY_TERR_GRP_ACCTS_S.nextval

350: sysdate,
351: p_user_id
352: );
353:
354: select JTF_TTY_TERR_GRP_ACCTS_S.nextval
355: into p_terr_gp_acct_id
356: from dual;
357:
358: -- assign a named account for the party to terr gp, if one does not exist

Line 362: insert into JTF_TTY_TERR_GRP_ACCTS

358: -- assign a named account for the party to terr gp, if one does not exist
359:
360: p_site_type_code := get_site_type_code(p_party_id);
361:
362: insert into JTF_TTY_TERR_GRP_ACCTS
363: (TERR_GROUP_ACCOUNT_ID,
364: OBJECT_VERSION_NUMBER ,
365: TERR_GROUP_ID ,
366: NAMED_ACCOUNT_ID,

Line 458: from JTF_TTY_TERR_GRP_ACCTS TGA

454: sysdate,
455: p_user_id
456: FROM jtf_tty_acct_rsc_dn
457: WHERE terr_group_account_id = (select TGA.terr_group_account_id
458: from JTF_TTY_TERR_GRP_ACCTS TGA
459: where TGA.named_account_id = p_ref_account_id
460: and TGA.terr_group_id = p_terr_gp_id);
461:
462: --API to re-create the summation table