DBA Data[Home] [Help]

APPS.OPI_OPM_COMMON_PKG dependencies on CM_CLDR_DTL

Line 240: FROM CM_RSRC_DTL a,CM_CLDR_DTL b,CM_CLDR_HDR c

236: FROM SY_ORGN_MST
237: WHERE ORGN_CODE=p_ORGN_CODE;
238: END IF;
239: SELECT NOMINAL_COST into l_rsrc_cost
240: FROM CM_RSRC_DTL a,CM_CLDR_DTL b,CM_CLDR_HDR c
241: WHERE a.ORGN_CODE=p_ORGN_CODE
242: AND a.CALENDAR_CODE=b.CALENDAR_CODE
243: AND a.PERIOD_CODE=b.PERIOD_CODE
244: AND a.COST_MTHD_CODE=l_cost_mthd