APPS.JTF_TTY_NA_TERRGP dependencies on JTF_TTY_ACCT_QUAL_MAPS

Line 261: DELETE from JTF_TTY_ACCT_QUAL_MAPS AQM

257: WHERE tga.named_account_id = A.named_account_id);
258:
259: -- Delete Named Account Qual Maps
260: FORALL idx in l_acctId_tbl.FIRST .. l_acctId_tbl.LAST
261: DELETE from JTF_TTY_ACCT_QUAL_MAPS AQM
262: WHERE AQM.NAMED_ACCOUNT_ID = l_acctId_tbl(idx)
263: AND NOT EXISTS ( SELECT 'x'
264: FROM JTF_TTY_NAMED_ACCTS a
265: WHERE a.named_account_id = AQM.named_account_id);

Line 413: DELETE FROM JTF_TTY_ACCT_QUAL_MAPS nam

409: WHERE na.NAMED_ACCOUNT_ID NOT IN
410: (SELECT named_account_id FROM JTF_TTY_TERR_GRP_ACCTS);
411: /* delete the na mappings if a na is deleted or no reference to it exists */
412:
413: DELETE FROM JTF_TTY_ACCT_QUAL_MAPS nam
414: WHERE nam.NAMED_ACCOUNT_ID NOT IN
415: (SELECT named_account_id FROM JTF_TTY_NAMED_ACCTS);
416:
417: /* delete all the terr gp owners, access and product */

Line 2848: INSERT INTO jtf_tty_acct_qual_maps

2844: NULL;
2845: END;
2846: IF (p_business_name IS NOT NULL) THEN
2847: /* key name for business name */
2848: INSERT INTO jtf_tty_acct_qual_maps
2849: (ACCOUNT_QUAL_MAP_ID,
2850: OBJECT_VERSION_NUMBER,
2851: NAMED_ACCOUNT_ID,
2852: QUAL_USG_ID,

Line 2861: SELECT jtf_tty_acct_qual_maps_s.NEXTVAL,

2857: CREATION_DATE,
2858: LAST_UPDATED_BY,
2859: LAST_UPDATE_DATE)
2860: (
2861: SELECT jtf_tty_acct_qual_maps_s.NEXTVAL,
2862: 1,
2863: p_acct_id,
2864: -1012,
2865: '=',

Line 2875: INSERT INTO jtf_tty_acct_qual_maps

2871: SYSDATE FROM dual);
2872: END IF;
2873: /* key name for trade name */
2874: IF (p_trade_name IS NOT NULL) THEN
2875: INSERT INTO jtf_tty_acct_qual_maps
2876: (ACCOUNT_QUAL_MAP_ID,
2877: OBJECT_VERSION_NUMBER,
2878: NAMED_ACCOUNT_ID,
2879: QUAL_USG_ID,

Line 2887: (SELECT jtf_tty_acct_qual_maps_s.NEXTVAL,

2883: CREATED_BY,
2884: CREATION_DATE,
2885: LAST_UPDATED_BY,
2886: LAST_UPDATE_DATE)
2887: (SELECT jtf_tty_acct_qual_maps_s.NEXTVAL,
2888: 1,
2889: p_acct_id,
2890: -1012,
2891: '=',

Line 2902: INSERT INTO jtf_tty_acct_qual_maps

2898: END IF;
2899:
2900: /* key name for postal code */
2901: IF (p_postal_code IS NOT NULL) THEN
2902: INSERT INTO jtf_tty_acct_qual_maps
2903: (ACCOUNT_QUAL_MAP_ID,
2904: OBJECT_VERSION_NUMBER,
2905: NAMED_ACCOUNT_ID,
2906: QUAL_USG_ID,

Line 2914: (SELECT jtf_tty_acct_qual_maps_s.NEXTVAL,

2910: CREATED_BY,
2911: CREATION_DATE,
2912: LAST_UPDATED_BY,
2913: LAST_UPDATE_DATE)
2914: (SELECT jtf_tty_acct_qual_maps_s.NEXTVAL,
2915: 1,
2916: p_acct_id,
2917: -1007,
2918: '=',