DBA Data[Home] [Help]

APPS.OZF_FUND_UTILIZED_PVT dependencies on QP_LIST_LINES

Line 311: FROM qp_list_lines line, qp_pricing_attributes attr

307: CURSOR c_get_deal_accrual_flag(p_qp_list_header_id IN NUMBER, p_product_type IN VARCHAR2, p_product_id IN NUMBER) IS
308: SELECT 1
309: FROM DUAL
310: WHERE EXISTS (SELECT 1
311: FROM qp_list_lines line, qp_pricing_attributes attr
312: WHERE attr.list_header_id = p_qp_list_header_id
313: AND line.list_line_id = attr.list_line_id
314: AND NVL(line.accrual_flag, 'N') = 'Y'
315: AND attr.product_attribute = DECODE(NVL(p_product_type, 'OTHER')