DBA Data[Home] [Help]

APPS.OZF_FUND_UTILIZED_PVT dependencies on QP_LIST_LINES

Line 206: FROM qp_list_lines line, qp_pricing_attributes attr

202: CURSOR c_get_deal_accrual_flag(p_qp_list_header_id IN NUMBER, p_product_type IN VARCHAR2, p_product_id IN NUMBER) IS
203: SELECT 1
204: FROM DUAL
205: WHERE EXISTS (SELECT 1
206: FROM qp_list_lines line, qp_pricing_attributes attr
207: WHERE attr.list_header_id = p_qp_list_header_id
208: AND line.list_line_id = attr.list_line_id
209: AND NVL(line.accrual_flag, 'N') = 'Y'
210: AND attr.product_attribute = DECODE(NVL(p_product_type, 'OTHER')