7895: AND c.qp_list_header_id = p_qp_list_header_id
7896: AND c.group_number = p_group_id;
7897:
7898: CURSOR c_sales_accrual(p_list_header_id IN NUMBER) IS
7899: SELECT 'X' from ozf_funds_all_b
7900: WHERE plan_id= p_list_header_id
7901: AND accrual_basis = 'SALES'
7902: UNION
7903: SELECT 'X' from ozf_funds_all_b
7899: SELECT 'X' from ozf_funds_all_b
7900: WHERE plan_id= p_list_header_id
7901: AND accrual_basis = 'SALES'
7902: UNION
7903: SELECT 'X' from ozf_funds_all_b
7904: WHERE plan_id = p_list_header_id
7905: AND accrual_basis = 'CUSTOMER'
7906: AND liability_flag = 'N';
7907: