APPS.ASO_VALIDATE_PVT dependencies on OE_LOOKUPS

Line 5022: SELECT start_date_active, end_date_active FROM OE_LOOKUPS

5018: p_freight_terms_code IN VARCHAR2)
5019: RETURN VARCHAR2
5020: IS
5021: CURSOR C_Freight_Terms IS
5022: SELECT start_date_active, end_date_active FROM OE_LOOKUPS
5023: WHERE lookup_type = 'FREIGHT_TERMS'
5024: AND enabled_flag = 'Y'
5025: AND lookup_code = p_freight_terms_code;
5026:

Line 5640: FROM oe_lookups

5636: CURSOR C_SHIPMENT_PRIORITY_CODE(p_shipment_priority_code varchar2) IS
5637: SELECT 1 FROM DUAL WHERE EXISTS
5638: (
5639: SELECT meaning shipment_priority
5640: FROM oe_lookups
5641: WHERE lookup_type = 'SHIPMENT_PRIORITY'
5642: AND enabled_flag = 'Y'
5643: AND trunc(sysdate) between nvl(start_date_active, trunc(sysdate)) and nvl(end_date_active, trunc(sysdate))
5644: AND lookup_code = p_shipment_priority_code

Line 5743: from oe_lookups

5739: CURSOR C_REQUEST_DATE_TYPE(p_lookup_code varchar2) is --Request Date Type
5740: SELECT 1 FROM DUAL WHERE exists
5741: (
5742: Select lookup_code
5743: from oe_lookups
5744: where lookup_type='REQUEST_DATE_TYPE'
5745: and lookup_code = p_lookup_code
5746: and ENABLED_FLAG = 'Y'
5747: and trunc(sysdate) between trunc(start_date_active)