DBA Data[Home] [Help]

APPS.GMF_CMCOMMON dependencies on CM_RSRC_DTL

Line 2397: * This function gets resource cost from cm_rsrc_dtl.

2393: * FUNCTION
2394: * get_rsrc_cost
2395: * DESCRIPTION
2396: *
2397: * This function gets resource cost from cm_rsrc_dtl.
2398: * This is being use in OPM Batch Cost Detail Report.
2399: *
2400: * AUTHOR
2401: * Anand Thiyagarajan 20-Feb-2007 Bug#5436964 Batches Across Periods FP

Line 2458: FROM cm_rsrc_dtl cst,

2454: v_cost_type_id NUMBER
2455: )
2456: IS
2457: SELECT nvl(sum(cst.nominal_cost), 0)
2458: FROM cm_rsrc_dtl cst,
2459: gmf_organization_definitions god,
2460: gmf_fiscal_policies f,
2461: gmf_period_statuses gps
2462: WHERE god.organization_id = v_organization_id