APPS.JTF_TTY_NA_WF dependencies on JTF_TTY_ACCT_QUAL_MAPS

Line 211: ' , JTF_TTY_ACCT_QUAL_MAPS QM_1007 '||

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 '||
215: ' AND QM_1007.QUAL_USG_ID = -1007 '||

Line 212: ' , JTF_TTY_ACCT_QUAL_MAPS QM_1012 '||

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 '||
215: ' AND QM_1007.QUAL_USG_ID = -1007 '||
216: ' AND QM_1007.NAMED_ACCOUNT_ID = QM_1012.NAMED_ACCOUNT_ID '||

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 475: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval

471: elsif (p_account_count = 1)
472: then
473: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('p_account_count = 1: Update mapping rules');
474: -- Update mapping rules for this existing named account by adding the postal code mapping
475: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval
476: into l_acct_qual_map_id
477: from dual;
478:
479: INSERT INTO JTF_TTY_ACCT_QUAL_MAPS

Line 479: INSERT INTO JTF_TTY_ACCT_QUAL_MAPS

475: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval
476: into l_acct_qual_map_id
477: from dual;
478:
479: INSERT INTO JTF_TTY_ACCT_QUAL_MAPS
480: (account_qual_map_id,
481: object_version_number,
482: named_account_id,
483: qual_usg_id,

Line 622: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval

618: l_acct_qual_map_id number;
619: BEGIN
620: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('begin create_mapping_rules');
621:
622: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval
623: into l_acct_qual_map_id
624: from dual;
625:
626: INSERT INTO JTF_TTY_ACCT_QUAL_MAPS

Line 626: INSERT INTO JTF_TTY_ACCT_QUAL_MAPS

622: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval
623: into l_acct_qual_map_id
624: from dual;
625:
626: INSERT INTO JTF_TTY_ACCT_QUAL_MAPS
627: (account_qual_map_id,
628: object_version_number,
629: named_account_id,
630: qual_usg_id,

Line 652: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval

648: , sysdate
649: , G_USER
650: , sysdate );
651:
652: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval
653: into l_acct_qual_map_id
654: from dual;
655:
656: INSERT INTO JTF_TTY_ACCT_QUAL_MAPS

Line 656: INSERT INTO JTF_TTY_ACCT_QUAL_MAPS

652: select JTF_TTY_ACCT_QUAL_MAPS_S.nextval
653: into l_acct_qual_map_id
654: from dual;
655:
656: INSERT INTO JTF_TTY_ACCT_QUAL_MAPS
657: (account_qual_map_id,
658: object_version_number,
659: named_account_id,
660: qual_usg_id,