[Home] [Help]
2571: * FUNCTION
2572: * get_rsrc_cost
2573: * DESCRIPTION
2574: *
2575: * This function gets resource cost from cm_rsrc_dtl.
2576: * This is being use in OPM Batch Cost Detail Report.
2577: *
2578: * AUTHOR
2579: * Anand Thiyagarajan 20-Feb-2007 Bug#5436964 Batches Across Periods FP
2632: v_cost_type_id NUMBER
2633: )
2634: IS
2635: SELECT nvl(sum(cst.nominal_cost), 0)
2636: FROM cm_rsrc_dtl cst,
2637: gmf_organization_definitions god,
2638: gmf_fiscal_policies f,
2639: gmf_period_statuses gps
2640: WHERE god.organization_id = v_organization_id