APPS.AHL_UMP_UNITMAINT_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 1236: FROM fnd_lookup_values_vl

1232: WHERE INSTANCE_NUMBER = p_instance_number;
1233:
1234: CURSOR l_get_status_code_csr(p_status_meaning IN VARCHAR2) IS
1235: SELECT LOOKUP_CODE
1236: FROM fnd_lookup_values_vl
1237: WHERE lookup_type = 'AHL_UNIT_EFFECTIVITY_STATUS' AND
1238: MEANING = p_status_meaning;
1239:
1240: l_mr_id NUMBER;

Line 1519: FROM FND_LOOKUP_VALUES_VL

1515: WHERE UNIT_EFFECTIVITY_ID = p_pred_ue_id;
1516:
1517: CURSOR l_validate_status_csr(p_status_code IN VARCHAR2) IS
1518: SELECT 'x'
1519: FROM FND_LOOKUP_VALUES_VL
1520: WHERE LOOKUP_TYPE = 'AHL_UNIT_EFFECTIVITY_STATUS' AND
1521: LOOKUP_CODE IN ('ACCOMPLISHED','INIT-ACCOMPLISHED','INIT-DUE','CANCELLED') AND
1522: LOOKUP_CODE = p_status_code;
1523: