[Home] [Help]
56: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
57: l_fetch_attempts := G_PRC_LST_DEF_ATTEMPTS;
58:
59:
60: /* Method code in so_price_list_lines can be either amount based or */
61: /* percentage based . */
62:
63: SELECT DISTINCT METHOD_CODE
64: INTO l_prc_method_code
61: /* percentage based . */
62:
63: SELECT DISTINCT METHOD_CODE
64: INTO l_prc_method_code
65: FROM so_price_list_lines
66: WHERE Price_List_Id = p_price_list_id
67: AND Inventory_Item_Id = p_inventory_item_id
68: AND Unit_Code = p_unit_Code;
69: