DBA Data[Home] [Help]

APPS.CE_CSH_FCST_POP dependencies on CE_PO_FC_REQUISITIONS_TEMP_V

Line 3832: FROM ce_po_fc_requisitions_temp_v

3828: (nvl(amount,0)/(trunc(end_date)-trunc(start_date)+1))) per_day_amount,
3829: start_date,
3830: nvl(end_date, l_max_end_date)end_date,
3831: end_date trx_end_date
3832: FROM ce_po_fc_requisitions_temp_v
3833: WHERE start_date <= p_end_date
3834: AND (end_date >= p_start_date
3835: OR end_date is NULL);
3836:

Line 3848: FROM ce_po_fc_requisitions_temp_v

3844: (nvl(amount,0)/(trunc(end_date)-trunc(start_date+1)))) per_day_amount,
3845: start_date,
3846: nvl(end_date, l_max_end_date)end_date,
3847: end_date trx_end_date
3848: FROM ce_po_fc_requisitions_temp_v
3849: WHERE start_date <= p_end_date
3850: AND (end_date >= p_start_date
3851: OR end_date is NULL)
3852: AND project_id = CE_CASH_FCST.G_rp_project_id;