APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on FND_LOOKUP_VALUES_VL

Line 3145: FROM fnd_lookup_values_vl

3141: -- CLM: Event Based Delivery Management
3142:
3143: update pon_item_prices_interface p
3144: set p.CLM_DELIVERY_EVENT_CODE = (SELECT lookup_code
3145: FROM fnd_lookup_values_vl
3146: WHERE lookup_type = 'CLM_DELIVERY_EVENT'
3147: AND meaning = p.CLM_DELIVERY_EVENT);
3148:
3149: insert into PON_INTERFACE_ERRORS

Line 3170: FROM fnd_lookup_values_vl

3166: and CLM_DELIVERY_EVENT IS NOT NULL;
3167:
3168: update pon_item_prices_interface p
3169: set p.CLM_DELIVERY_PERIOD_UOM_CODE = (SELECT lookup_code
3170: FROM fnd_lookup_values_vl
3171: WHERE lookup_type = 'CLM_PERIOD'
3172: AND meaning = p.CLM_DELIVERY_PERIOD_UOM);
3173:
3174: insert into PON_INTERFACE_ERRORS

Line 3195: FROM fnd_lookup_values_vl

3191: and CLM_DELIVERY_PERIOD_UOM IS NOT NULL;
3192:
3193: update pon_item_prices_interface p
3194: set p.CLM_POP_DURATION_UOM_CODE = (SELECT lookup_code
3195: FROM fnd_lookup_values_vl
3196: WHERE lookup_type = 'CLM_PERIOD'
3197: AND meaning = p.CLM_POP_DURATION_UOM);
3198:
3199: insert into PON_INTERFACE_ERRORS