APPS.OZF_QP_DISCOUNTS_PVT dependencies on QP_LIST_LINES

Line 30: SELECT 'X' FROM qp_list_lines a, ozf_offer_discount_lines b, ozf_offers c WHERE

26: CURSOR c_valid_offer(p_offer_discount_line_id NUMBER, p_list_line_id NUMBER) IS
27: SELECT 1 FROM DUAL
28: WHERE exists
29: (
30: SELECT 'X' FROM qp_list_lines a, ozf_offer_discount_lines b, ozf_offers c WHERE
31: a.list_header_id = c.qp_list_header_id
32: AND b.offer_id = c.offer_id
33: AND a.list_line_id = p_list_line_id
34: AND b.offer_discount_line_id = p_offer_discount_line_id

Line 140: IF ozf_utility_pvt.check_fk_exists('qp_list_lines', 'list_line_id',to_char(p_qp_disc_rec.list_line_id)) = FND_API.G_FALSE THEN

136: IS
137: BEGIN
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139: IF p_qp_disc_rec.list_line_id IS NOT NULL AND p_qp_disc_rec.list_line_id <> FND_API.G_MISS_NUM THEN
140: IF ozf_utility_pvt.check_fk_exists('qp_list_lines', 'list_line_id',to_char(p_qp_disc_rec.list_line_id)) = FND_API.G_FALSE THEN
141: OZF_Utility_PVT.Error_Message('OZF_QP_DISC_INV_LLID');
142: x_return_status := FND_API.g_ret_sts_error;
143: return;
144: END IF;