APPS.AS_SALES_LEADS_PVT dependencies on AS_LOOKUPS

Line 1217: FROM as_lookups

1213: )
1214: IS
1215: CURSOR C_Lookup_Exists (X_Lookup_Code VARCHAR2, X_Lookup_Type VARCHAR2) IS
1216: SELECT 'X'
1217: FROM as_lookups
1218: WHERE lookup_type = X_Lookup_Type
1219: and lookup_code = X_Lookup_Code
1220: -- ffang 012501
1221: and enabled_flag = 'Y';

Line 1277: FROM as_lookups

1273: )
1274: IS
1275: CURSOR C_Lookup_Exists (X_Lookup_Code VARCHAR2, X_Lookup_Type VARCHAR2) IS
1276: SELECT 'X'
1277: FROM as_lookups
1278: WHERE lookup_type = X_Lookup_Type
1279: and lookup_code = X_Lookup_Code
1280: -- ffang 012501
1281: and enabled_flag = 'Y';

Line 1534: FROM as_lookups

1530: )
1531: IS
1532: CURSOR C_Lookup_Exists (X_Lookup_Code VARCHAR2, X_Lookup_Type VARCHAR2) IS
1533: SELECT 'X'
1534: FROM as_lookups
1535: WHERE lookup_type = X_Lookup_Type
1536: and lookup_code = X_Lookup_Code
1537: -- ffang 012501
1538: and enabled_flag = 'Y';

Line 1594: FROM as_lookups

1590: )
1591: IS
1592: CURSOR C_Lookup_Exists (X_Lookup_Code VARCHAR2, X_Lookup_Type VARCHAR2) IS
1593: SELECT 'X'
1594: FROM as_lookups
1595: WHERE lookup_type = X_Lookup_Type
1596: and lookup_code = X_Lookup_Code
1597: -- ffang 012501
1598: and enabled_flag = 'Y';

Line 1654: FROM as_lookups

1650: )
1651: IS
1652: CURSOR C_Lookup_Exists (X_Lookup_Code VARCHAR2, X_Lookup_Type VARCHAR2) IS
1653: SELECT 'X'
1654: FROM as_lookups
1655: WHERE lookup_type = X_Lookup_Type
1656: and lookup_code = X_Lookup_Code
1657: -- ffang 012501
1658: and enabled_flag = 'Y';

Line 2331: FROM as_lookups

2327: )
2328: IS
2329: CURSOR C_PRM_LEAD_TYPE_Exists (c_Lookup_Code VARCHAR2) IS
2330: SELECT 'X'
2331: FROM as_lookups
2332: WHERE lookup_type = 'PRM_LEAD_TYPE'
2333: and lookup_code = c_Lookup_Code;
2334: l_val VARCHAR2(1);
2335:

Line 2355: -- PRM_LEAD_TYPE should exist in as_lookups

2351:
2352: IF (p_PRM_LEAD_TYPE is NOT NULL) and
2353: (p_PRM_LEAD_TYPE <> FND_API.G_MISS_CHAR)
2354: THEN
2355: -- PRM_LEAD_TYPE should exist in as_lookups
2356: OPEN C_PRM_LEAD_TYPE_Exists (p_PRM_LEAD_TYPE);
2357: FETCH C_PRM_LEAD_TYPE_Exists into l_val;
2358:
2359: IF C_PRM_LEAD_TYPE_Exists%NOTFOUND THEN

Line 2398: FROM as_lookups

2394: )
2395: IS
2396: CURSOR C_PRM_IND_CLS_CODE_Exists (c_Lookup_Code VARCHAR2) IS
2397: SELECT 'X'
2398: FROM as_lookups
2399: WHERE lookup_type = 'PRM_IND_CLASSIFICATION_TYPE'
2400: and lookup_code = c_Lookup_Code;
2401: l_val VARCHAR2(1);
2402:

Line 2422: -- PRM_IND_CLASSIFICATION_CODE should exist in as_lookups

2418:
2419: IF (p_PRM_IND_CLASSIFICATION_CODE is NOT NULL) and
2420: (p_PRM_IND_CLASSIFICATION_CODE <> FND_API.G_MISS_CHAR)
2421: THEN
2422: -- PRM_IND_CLASSIFICATION_CODE should exist in as_lookups
2423: OPEN C_PRM_IND_CLS_CODE_Exists (p_PRM_IND_CLASSIFICATION_CODE);
2424: FETCH C_PRM_IND_CLS_CODE_Exists into l_val;
2425:
2426: IF C_PRM_IND_CLS_CODE_Exists%NOTFOUND THEN

Line 2467: FROM as_lookups

2463: IS
2464: CURSOR C_AUTO_ASGN_TYPE_Exists (c_lookup_type VARCHAR2,
2465: c_Lookup_Code VARCHAR2) IS
2466: SELECT 'X'
2467: FROM as_lookups
2468: WHERE lookup_type = c_lookup_type
2469: and lookup_code = c_Lookup_Code;
2470: l_val VARCHAR2(1);
2471:

Line 2487: -- AUTO_ASSIGNMENT_TYPE should exist in as_lookups

2483:
2484: IF (p_AUTO_ASSIGNMENT_TYPE is NOT NULL) and
2485: (p_AUTO_ASSIGNMENT_TYPE <> FND_API.G_MISS_CHAR)
2486: THEN
2487: -- AUTO_ASSIGNMENT_TYPE should exist in as_lookups
2488: OPEN C_AUTO_ASGN_TYPE_Exists ('AUTO_ASSIGNMENT_TYPE',
2489: p_AUTO_ASSIGNMENT_TYPE);
2490: FETCH C_AUTO_ASGN_TYPE_Exists into l_val;
2491:

Line 2530: FROM as_lookups

2526: IS
2527: CURSOR C_PRM_ASGN_TYPE_Exists (c_lookup_type VARCHAR2,
2528: c_Lookup_Code VARCHAR2) IS
2529: SELECT 'X'
2530: FROM as_lookups
2531: WHERE lookup_type = c_lookup_type
2532: and lookup_code = c_Lookup_Code;
2533: l_val VARCHAR2(1);
2534:

Line 2548: -- PRM_ASSIGNMENT_TYPE should exist in as_lookups

2544:
2545: IF (p_PRM_ASSIGNMENT_TYPE is NOT NULL) and
2546: (p_PRM_ASSIGNMENT_TYPE <> FND_API.G_MISS_CHAR)
2547: THEN
2548: -- PRM_ASSIGNMENT_TYPE should exist in as_lookups
2549: OPEN C_PRM_ASGN_TYPE_Exists ('PRM_ASSIGNMENT_TYPE',
2550: p_PRM_ASSIGNMENT_TYPE);
2551: FETCH C_PRM_ASGN_TYPE_Exists into l_val;
2552: