APPS.AHL_UMP_UNITMAINT_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 1057: FROM fnd_lookup_values_vl

1053: WHERE INSTANCE_NUMBER = p_instance_number;
1054:
1055: CURSOR l_get_status_code_csr(p_status_meaning IN VARCHAR2) IS
1056: SELECT LOOKUP_CODE
1057: FROM fnd_lookup_values_vl
1058: WHERE lookup_type = 'AHL_UNIT_EFFECTIVITY_STATUS' AND
1059: MEANING = p_status_meaning;
1060:
1061: l_mr_id NUMBER;

Line 1339: FROM FND_LOOKUP_VALUES_VL

1335: WHERE UNIT_EFFECTIVITY_ID = p_pred_ue_id;
1336:
1337: CURSOR l_validate_status_csr(p_status_code IN VARCHAR2) IS
1338: SELECT 'x'
1339: FROM FND_LOOKUP_VALUES_VL
1340: WHERE LOOKUP_TYPE = 'AHL_UNIT_EFFECTIVITY_STATUS' AND
1341: LOOKUP_CODE IN ('ACCOMPLISHED','INIT-ACCOMPLISHED','INIT-DUE','CANCELLED') AND
1342: LOOKUP_CODE = p_status_code;
1343: