3839: AND c.qp_list_header_id = p_qp_list_header_id
3840: AND c.group_number = p_group_id;
3841:
3842: CURSOR c_sales_accrual(p_list_header_id IN NUMBER) IS
3843: SELECT 'X' from ozf_funds_all_b
3844: WHERE plan_id= p_list_header_id
3845: AND accrual_basis = 'SALES'
3846: UNION
3847: SELECT 'X' from ozf_funds_all_b
3843: SELECT 'X' from ozf_funds_all_b
3844: WHERE plan_id= p_list_header_id
3845: AND accrual_basis = 'SALES'
3846: UNION
3847: SELECT 'X' from ozf_funds_all_b
3848: WHERE plan_id = p_list_header_id
3849: AND accrual_basis = 'CUSTOMER'
3850: AND liability_flag = 'N';
3851: