DBA Data[Home] [Help]

APPS.PON_RESPONSE_IMPORT_PKG dependencies on FND_LOOKUP_VALUES_VL

Line 969: FROM fnd_lookup_values_vl

965: BEGIN
966:
967: update pon_bid_item_prices_interface p
968: set p.CLM_PROMISE_PERIOD_UOM_CODE = (SELECT lookup_code
969: FROM fnd_lookup_values_vl
970: WHERE lookup_type = 'CLM_PERIOD'
971: AND meaning = p.CLM_PROMISE_PERIOD_UOM);
972:
973: INSERT INTO pon_interface_errors

Line 1014: FROM fnd_lookup_values_vl

1010: and p.CLM_PROMISE_PERIOD_UOM IS NOT NULL;
1011:
1012: update pon_bid_item_prices_interface p
1013: set p.CLM_PROMISE_POP_DUR_UOM_CODE = (SELECT lookup_code
1014: FROM fnd_lookup_values_vl
1015: WHERE lookup_type = 'CLM_PERIOD'
1016: AND meaning = p.CLM_PROMISE_POP_DURATION_UOM);
1017:
1018: INSERT INTO pon_interface_errors