APPS.AS_OPP_CONTACT_PVT dependencies on AS_LOOKUPS

Line 1526: FROM as_lookups

1522: IS
1523:
1524: CURSOR C_RANK_Exists (c_RANK VARCHAR2) IS
1525: SELECT 'X'
1526: FROM as_lookups
1527: WHERE lookup_type = 'CONTACT_RANK_ON_OPPORTUNITY'
1528: and lookup_code = c_RANK
1529: and enabled_flag = 'Y';
1530:

Line 1549: -- RANK should exist in as_lookups

1545:
1546: IF (p_RANK is NOT NULL) and
1547: (p_RANK <> FND_API.G_MISS_CHAR)
1548: THEN
1549: -- RANK should exist in as_lookups
1550: OPEN C_RANK_Exists ( p_RANK);
1551: FETCH C_RANK_Exists into l_val;
1552: IF C_RANK_Exists%NOTFOUND THEN
1553: IF l_debug THEN