DBA Data[Home] [Help]

APPS.OZF_SUPP_TRADE_PROFILE_PUB dependencies on QP_PRICE_FORMULAS_VL

Line 502: FROM qp_price_formulas_vl formula

498: IF ( p_supp_trade_profile_rec.claim_computation_basis <>FND_API.g_miss_num
499: AND p_supp_trade_profile_rec.claim_computation_basis IS NOT NULL ) THEN
500:
501: SELECT COUNT(*) INTO l_comp_baisis_count
502: FROM qp_price_formulas_vl formula
503: WHERE trunc(sysdate) BETWEEN nvl(start_date_active, trunc(sysdate))
504: AND nvl(end_date_active, trunc(sysdate))
505: AND formula.price_formula_id = p_supp_trade_profile_rec.claim_computation_basis ;
506: