DBA Data[Home] [Help]

APPS.MRP_CRP_HORIZONTAL_PLAN dependencies on CST_RESOURCE_COSTS

Line 1281: FROM cst_resource_costs res

1277:
1278: BEGIN
1279: SELECT (1 + v_overhead)*NVL(res.resource_rate,0)
1280: INTO v_res_cost
1281: FROM cst_resource_costs res
1282: WHERE res.organization_id = p_org_id
1283: AND res.resource_id = p_res_id
1284: AND res.cost_type_id = CST_FROZEN;
1285: EXCEPTION when no_data_found THEN

Line 1296: FROM cst_resource_costs res

1292:
1293: BEGIN
1294: SELECT NVL(res.resource_rate,0)
1295: INTO v_res_cost
1296: FROM cst_resource_costs res
1297: WHERE res.organization_id = p_org_id
1298: AND res.resource_id = p_res_id
1299: AND res.cost_type_id = CST_FROZEN;
1300: EXCEPTION when no_data_found THEN