APPS.CSD_ESTIMATE_UTILS_PVT dependencies on FND_LOOKUP_VALUES

Line 77: FROM fnd_lookup_values_vl

73: FUNCTION VALIDATE_EST_STATUS(p_estimate_status VARCHAR2) RETURN BOOLEAN IS
74: --Cursor to validate estimate status
75: CURSOR CUR_EST_STATUS(p_estimate_status VARCHAR2) IS
76: SELECT 1 col1
77: FROM fnd_lookup_values_vl
78: WHERE lookup_type = 'CSD_ESTIMATE_STATUS'
79: AND enabled_flag = 'Y'
80: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE)) AND
81: TRUNC(NVL(end_date_active, SYSDATE))

Line 114: FROM fnd_lookup_values_vl

110: p_status VARCHAR2) RETURN BOOLEAN IS
111: --Cursor to validate estimate status
112: CURSOR CUR_REJECT_REASON IS
113: SELECT 1 col1
114: FROM fnd_lookup_values_vl
115: WHERE lookup_type = DECODE(p_status,
116: C_EST_STATUS_REJECTED,
117: 'CSD_REJECT_REASON',
118: C_EST_STATUS_ACCEPTED,

Line 152: FROM fnd_lookup_values_vl

148: FUNCTION VALIDATE_LEAD_TIME_UOM(p_lead_time_uom VARCHAR2) RETURN BOOLEAN IS
149: --Cursor to validate estimate status
150: CURSOR CUR_LEAD_TIME_UOM IS
151: SELECT 1 col1
152: FROM fnd_lookup_values_vl
153: WHERE lookup_type = 'CSD_UNIT_OF_MEASURE'
154: AND enabled_flag = 'Y'
155: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE)) AND
156: TRUNC(NVL(end_date_active, SYSDATE))

Line 391: FROM fnd_lookup_values

387: FUNCTION VALIDATE_BILLING_TYPE(p_billing_type VARCHAR2) RETURN BOOLEAN IS
388:
389: CURSOR c1 IS
390: SELECT 1 col1
391: FROM fnd_lookup_values
392: WHERE lookup_code = P_BILLING_TYPE
393: AND lookup_type = 'CSD_EST_BILLING_TYPE'
394: AND enabled_flag = 'Y'
395: AND LANGUAGE = 'US'