ACS3 Data Model

     1: function im_projects_setup_fee(v_group_id IN integer, v_start_block IN date, v_end_block in date)
     2: return number
     3: is
     4:    monthly_fee      	number(10,2);
     5: BEGIN
     6: 
     7: select sum(fee) into monthly_fee from
     8: im_project_payments
     9: where im_project_payments.group_id = v_group_id
    10: and start_block >= v_start_block
    11: and start_block < v_end_block
    12: and fee_type= 'setup'
    13: group by group_id;
    14: 
    15: return monthly_fee;
    16: 
    17: END im_projects_setup_fee;