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 3099: -- Use JTF_QUAL_USGS_ALL, instead of JTF_QUAL_USGS(with security policies)

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

Line 3104: FROM JTF_QUAL_USGS_ALL Amount

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

Line 3111: FROM JTF_QUAL_USGS_ALL Promotion

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

Line 3119: FROM JTF_QUAL_USGS_ALL Channel

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

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

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

Line 3247: FROM JTF_QUAL_USGS_ALL ItemNo

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

Line 3254: FROM JTF_QUAL_USGS_ALL Expected

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

Line 3261: FROM JTF_QUAL_USGS_ALL Amount

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