APPS.OZF_QP_PRODUCTS_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 118: IF ozf_utility_pvt.check_fk_exists('qp_pricing_attributes','pricing_attribute_id',to_char(p_qp_product_rec.pricing_attribute_id)) = FND_API.g_false THEN

114: END IF;
115: END IF;
116:
117: IF p_qp_product_rec.pricing_attribute_id IS NOT NULL AND p_qp_product_rec.pricing_attribute_id <> FND_API.G_MISS_NUM THEN
118: IF ozf_utility_pvt.check_fk_exists('qp_pricing_attributes','pricing_attribute_id',to_char(p_qp_product_rec.pricing_attribute_id)) = FND_API.g_false THEN
119: OZF_Utility_PVT.Error_Message('OZF_INVALID_OZF_PROD_ID' );
120: x_return_status := FND_API.g_ret_sts_error;
121: return;
122: END IF;

Line 135: SELECT list_header_id FROM qp_pricing_attributes WHERE pricing_attribute_id = p_pricing_attribute_id;

131: )
132: IS
133: CURSOR c_list_header(p_pricing_attribute_id NUMBER)
134: IS
135: SELECT list_header_id FROM qp_pricing_attributes WHERE pricing_attribute_id = p_pricing_attribute_id;
136: l_list_header NUMBER;
137: CURSOR c_list_header2 (p_off_discount_product_id NUMBER)
138: IS
139: SELECT qp_list_header_id FROM ozf_offers WHERE offer_id = (SELECT offer_id FROM ozf_offer_discount_products WHERE off_discount_product_id = p_off_discount_product_id);