APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 193: FROM financials_system_params_all

189: BEGIN
190:
191: SELECT inventory_organization_id
192: INTO p_inventory_org
193: FROM financials_system_params_all
194: WHERE nvl(org_id, -9999) = nvl(p_org_id, -9999);
195:
196:
197: EXCEPTION

Line 3131: financials_system_params_all fsp

3127: OR (l_is_fed = 'N' AND (ip.need_by_date is null AND ip.need_by_start_date is NULL)))
3128: and ip.item_id is not null
3129: and exists ( SELECT 'x'
3130: FROM mtl_system_items_kfv msi,
3131: financials_system_params_all fsp
3132: WHERE nvl(fsp.org_id, -9999) = nvl(p_org_id,-9999)
3133: and msi.organization_id = fsp.inventory_organization_id
3134: and msi.inventory_item_id = ip.item_id
3135: and (msi.INVENTORY_PLANNING_CODE in (1, 2) or msi.MRP_PLANNING_CODE in