APPS.MRP_CRP_HORIZONTAL_PLAN dependencies on CST_DEPARTMENT_OVERHEADS

Line 1269: FROM cst_department_overheads

1265:
1266: /***** Bug 1965639
1267: SELECT SUM(NVL(rate_or_amount,0))
1268: INTO v_overhead
1269: FROM cst_department_overheads
1270: WHERE organization_id = p_org_id
1271: AND department_id = p_dept_id
1272: AND cost_type_id = CST_FROZEN;
1273:

Line 1312: FROM cst_department_overheads

1308:
1309: SELECT SUM(decode(basis_type,BASIS_RESOURCE_VALUE, v_res_cost * NVL(rate_or_amount,0),
1310: NVL(rate_or_amount,0)))
1311: INTO v_overhead
1312: FROM cst_department_overheads
1313: WHERE organization_id = p_org_id
1314: AND department_id = p_dept_id
1315: AND cost_type_id = CST_FROZEN
1316: AND basis_type in (BASIS_RESOURCE_VALUE, BASIS_RESOURCE_UNITS)