[Home] [Help]
2581: 3, p_res_units,
2582: p_res_value), l_ext_precision) rbo_value,
2583: cdo.department_id
2584: FROM cst_resource_overheads cro,
2585: cst_department_overheads cdo
2586: WHERE cdo.department_id = p_dept_id
2587: AND cdo.organization_id = p_org_id
2588: AND cdo.cost_type_id = l_rates_ct
2589: AND cdo.basis_type IN (3,4)
2873: cdo.department_id department_id ,
2874: wo.operation_seq_num operation_seq_num
2875:
2876: FROM wip_operations wo,
2877: cst_department_overheads cdo
2878: WHERE cdo.cost_type_id = l_rates_ct
2879: AND cdo.organization_id = l_organization_id
2880: AND cdo.department_id = wo.department_id
2881: AND wo.wip_entity_id = p_wip_entity_id