DBA Data[Home] [Help]

APPS.OZF_RESALE_COMMON_PVT dependencies on QP_LIST_LINES

Line 6810: FROM qp_list_lines line, qp_pricing_attributes attr

6806: CURSOR c_get_deal_accrual_flag(p_qp_list_header_id IN NUMBER, p_product_type IN VARCHAR2, p_product_id IN NUMBER) IS
6807: SELECT 1
6808: FROM DUAL
6809: WHERE EXISTS (SELECT 1
6810: FROM qp_list_lines line, qp_pricing_attributes attr
6811: WHERE attr.list_header_id = p_qp_list_header_id
6812: AND line.list_line_id = attr.list_line_id
6813: AND NVL(line.accrual_flag, 'N') = 'Y'
6814: AND attr.product_attribute = DECODE(NVL(p_product_type, 'OTHER')