2974: (nvl(amount,0)/(trunc(end_date)-trunc(start_date)+1))) per_day_amount,
2975: start_date,
2976: nvl(end_date, l_max_end_date)end_date,
2977: end_date trx_end_date
2978: FROM ce_po_fc_no_terms_temp_v
2979: WHERE start_date <= p_end_date
2980: AND (end_date >= p_start_date
2981: OR end_date is NULL));
2982:
3045: (nvl(amount,0)/(trunc(end_date)-trunc(start_date)+1))) per_day_amount,
3046: start_date,
3047: nvl(end_date, l_max_end_date)end_date,
3048: end_date trx_end_date
3049: FROM ce_po_fc_no_terms_temp_v
3050: WHERE start_date <= p_end_date
3051: AND (end_date >= p_start_date
3052: OR end_date is NULL)
3053: AND project_id = CE_CASH_FCST.G_rp_project_id);