APPS.ASO_VALIDATE_PVT dependencies on OE_LOOKUPS

Line 5019: SELECT start_date_active, end_date_active FROM OE_LOOKUPS

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

Line 5624: FROM oe_lookups

5620: CURSOR C_SHIPMENT_PRIORITY_CODE(p_shipment_priority_code varchar2) IS
5621: SELECT 1 FROM DUAL WHERE EXISTS
5622: (
5623: SELECT meaning shipment_priority
5624: FROM oe_lookups
5625: WHERE lookup_type = 'SHIPMENT_PRIORITY'
5626: AND enabled_flag = 'Y'
5627: AND trunc(sysdate) between nvl(start_date_active, trunc(sysdate)) and nvl(end_date_active, trunc(sysdate))
5628: AND lookup_code = p_shipment_priority_code

Line 5727: from oe_lookups

5723: CURSOR C_REQUEST_DATE_TYPE(p_lookup_code varchar2) is --Request Date Type
5724: SELECT 1 FROM DUAL WHERE exists
5725: (
5726: Select lookup_code
5727: from oe_lookups
5728: where lookup_type='REQUEST_DATE_TYPE'
5729: and lookup_code = p_lookup_code
5730: and ENABLED_FLAG = 'Y'
5731: and trunc(sysdate) between trunc(start_date_active)