APPS.AS_SCORECARD_RULES_PVT dependencies on AS_SALES_LEAD_QUALS_VL

Line 80: FROM AS_SALES_LEAD_QUALS_VL

76: IS
77: CURSOR C_GET_SEED (IN_SEED_QUAL_ID NUMBER) IS
78: SELECT
79: SEED_QUAL_ID
80: FROM AS_SALES_LEAD_QUALS_VL
81: WHERE SEED_QUAL_ID = IN_SEED_QUAL_ID;
82: --
83: l_SEED_QUAL_ID NUMBER;
84:

Line 139: FROM AS_SALES_LEAD_QUALS_VL

135: SELECT
136: SEED_QUAL_ID,
137: UPPER(RANGE_FLAG),
138: UPPER(DATA_TYPE)
139: FROM AS_SALES_LEAD_QUALS_VL
140: WHERE SEED_QUAL_ID = IN_SEED_QUAL_ID;
141:
142: l_SEED_QUAL_ID NUMBER;
143: l_RANGE_FLAG VARCHAR2(1);

Line 237: FROM AS_SALES_LEAD_QUALS_VL

233: SELECT
234: SEED_QUAL_ID,
235: UPPER(RANGE_FLAG),
236: UPPER(DATA_TYPE)
237: FROM AS_SALES_LEAD_QUALS_VL
238: WHERE SEED_QUAL_ID = IN_SEED_QUAL_ID;
239: --
240: l_SEED_QUAL_ID NUMBER;
241: l_RANGE_FLAG VARCHAR2(1);

Line 336: FROM AS_SALES_LEAD_QUALS_VL

332: SELECT
333: SEED_QUAL_ID,
334: UPPER(RANGE_FLAG),
335: UPPER(DATA_TYPE)
336: FROM AS_SALES_LEAD_QUALS_VL
337: WHERE SEED_QUAL_ID = IN_SEED_QUAL_ID;
338: --
339: l_SEED_QUAL_ID NUMBER;
340: l_RANGE_FLAG VARCHAR2(1);