DBA Data[Home] [Help]

APPS.MSC_WS_COLLECTIONS dependencies on FND_LOOKUP_VALUES_VL

Line 1773: FROM fnd_lookup_values_vl flv

1769: cCode NUMBER;
1770: BEGIN
1771:
1772: SELECT lookup_code INTO cCode
1773: FROM fnd_lookup_values_vl flv
1774: WHERE flv.lookup_type = 'MSD_DEM_COLL_METHODS'
1775: AND flv.lookup_code = methodCode;
1776:
1777: RETURN true;

Line 1798: SELECT lookup_code into cCode from fnd_lookup_values_vl flv

1794: BEGIN
1795: -- If collection method is 2 (Netchange), then the dateRangeType
1796: -- Is required. Otherwise, dateRangeType need to be NULL
1797: IF (CollectionMethod = 2) THEN
1798: SELECT lookup_code into cCode from fnd_lookup_values_vl flv
1799: WHERE flv.lookup_type = 'MSD_DEM_DATE_RANGE_TYPES'
1800: --AND '1' = hiddenParam
1801: AND lookup_code= dateRangeType;
1802: