APPS.AS_SALES_LEAD_ASSIGN_PVT dependencies on JTF_QUAL_USGS_ALL

Line 81: -- Use JTF_QUAL_USGS_ALL, instead of JTF_QUAL_USGS(with

77: -- Set UPPER for all VARCHAR2 qualifier.
78: -- 07/10/2003 SOLIN Bug 3046959(Bug 2983881 for 11.5.8)
79: -- Change for new DUN's number qualifier
80: -- 08/07/2003 SOLIN Bug 3091085(Bug 3087354 for 11.5.8)
81: -- Use JTF_QUAL_USGS_ALL, instead of JTF_QUAL_USGS(with
82: -- security policies)
83: -- 10/23/2003 SOLIN ER 3052066
84: -- Leave a record in as_changed_accounts after
85: -- (Re)Build_lead_sales_team. TAP New mode need this

Line 3098: -- Use JTF_QUAL_USGS_ALL, instead of JTF_QUAL_USGS(with security policies)

3094: l_insert_flag VARCHAR2(1) := 'N';
3095: l_incubation_channel VARCHAR2(30);
3096:
3097: -- Bug 3091085, SOLIN(Bug 3087354 for 11.5.8)
3098: -- Use JTF_QUAL_USGS_ALL, instead of JTF_QUAL_USGS(with security policies)
3099: -- This SQL is ordered by decending Enabled_Flag because sales team should
3100: -- be rebuilt as long as any org. has enabled the qualifier.
3101: CURSOR c1 IS
3102: SELECT Amount.Enabled_Flag

Line 3103: FROM JTF_QUAL_USGS_ALL Amount

3099: -- This SQL is ordered by decending Enabled_Flag because sales team should
3100: -- be rebuilt as long as any org. has enabled the qualifier.
3101: CURSOR c1 IS
3102: SELECT Amount.Enabled_Flag
3103: FROM JTF_QUAL_USGS_ALL Amount
3104: WHERE Amount.QUAL_USG_ID = -1021
3105: AND Amount.QUAL_TYPE_USG_ID = -1002 -- LEAD
3106: ORDER BY Amount.Enabled_Flag DESC;
3107:

Line 3110: FROM JTF_QUAL_USGS_ALL Promotion

3106: ORDER BY Amount.Enabled_Flag DESC;
3107:
3108: CURSOR c2 IS
3109: SELECT Promotion.Enabled_Flag
3110: FROM JTF_QUAL_USGS_ALL Promotion
3111: WHERE Promotion.QUAL_USG_ID = -1020
3112: AND Promotion.QUAL_TYPE_USG_ID = -1002 -- LEAD
3113: ORDER BY Promotion.Enabled_Flag DESC;
3114:

Line 3118: FROM JTF_QUAL_USGS_ALL Channel

3114:
3115: -- JTF Bug 2725578: SALES CHANNEL SUPPORT FOR TERRITORY ASSIGNMENT
3116: CURSOR c3 IS
3117: SELECT Channel.Enabled_Flag
3118: FROM JTF_QUAL_USGS_ALL Channel
3119: WHERE Channel.QUAL_USG_ID = -1130
3120: AND Channel.QUAL_TYPE_USG_ID = -1002 -- LEAD
3121: ORDER BY Channel.Enabled_Flag DESC;
3122: BEGIN

Line 3241: -- Use JTF_QUAL_USGS_ALL, instead of JTF_QUAL_USGS(with security policies)

3237: FROM AS_SALES_LEADS lead
3238: WHERE lead.sales_lead_Id = C_Sales_Lead_Id;
3239:
3240: -- Bug 3091085, SOLIN(Bug 3087354 for 11.5.8)
3241: -- Use JTF_QUAL_USGS_ALL, instead of JTF_QUAL_USGS(with security policies)
3242: -- This SQL is ordered by decending Enabled_Flag because sales team should
3243: -- be rebuilt as long as any org. has enabled the qualifier.
3244: CURSOR c1 IS
3245: SELECT ItemNo.Enabled_Flag

Line 3246: FROM JTF_QUAL_USGS_ALL ItemNo

3242: -- This SQL is ordered by decending Enabled_Flag because sales team should
3243: -- be rebuilt as long as any org. has enabled the qualifier.
3244: CURSOR c1 IS
3245: SELECT ItemNo.Enabled_Flag
3246: FROM JTF_QUAL_USGS_ALL ItemNo
3247: WHERE ItemNo.QUAL_USG_ID = -1019
3248: AND ItemNo.QUAL_TYPE_USG_ID = -1002 -- Lead
3249: ORDER BY ItemNo.Enabled_Flag DESC;
3250:

Line 3253: FROM JTF_QUAL_USGS_ALL Expected

3249: ORDER BY ItemNo.Enabled_Flag DESC;
3250:
3251: CURSOR c2 IS
3252: SELECT Expected.Enabled_Flag
3253: FROM JTF_QUAL_USGS_ALL Expected
3254: WHERE Expected.QUAL_USG_ID = -1018
3255: AND Expected.QUAL_TYPE_USG_ID = -1002 -- Lead
3256: ORDER BY Expected.Enabled_Flag DESC;
3257:

Line 3260: FROM JTF_QUAL_USGS_ALL Amount

3256: ORDER BY Expected.Enabled_Flag DESC;
3257:
3258: CURSOR c3 IS
3259: SELECT Amount.Enabled_Flag
3260: FROM JTF_QUAL_USGS_ALL Amount
3261: WHERE Amount.QUAL_USG_ID = -1022
3262: AND Amount.QUAL_TYPE_USG_ID = -1002 -- Lead
3263: ORDER BY Amount.Enabled_Flag DESC;
3264: BEGIN