DBA Data[Home] [Help]

APPS.EAM_CONSTRUCTION_EST_PVT dependencies on CST_RESOURCE_COSTS

Line 118: FROM CST_RESOURCE_COSTS CRC, BOM_RESOURCES BR

114: SELECT ROUND(DECODE(BR.FUNCTIONAL_CURRENCY_FLAG, 1, 1,
115: NVL(CRC.RESOURCE_RATE,0)) * 1 -- 1 TO REPRESENT UNIT RESOURCE QUANTITY
116: * DECODE(NULL, 1, NULL, 2, 1, 1) ,p_ext_precision)
117: INTO X_UNIT_RESOURCE_VALUE
118: FROM CST_RESOURCE_COSTS CRC, BOM_RESOURCES BR
119: WHERE CRC.RESOURCE_ID = p_resource_id
120: AND BR.RESOURCE_ID = CRC.RESOURCE_ID
121: AND BR.ORGANIZATION_ID = p_org_id
122: AND CRC.COST_TYPE_ID = p_cost_type_id;