[Home] [Help]
1107: p_res_value) applied_value,
1108: decode(cdo.basis_type, 3, p_res_units,
1109: p_res_value) basis_units
1110: FROM cst_resource_overheads cro,
1111: cst_department_overheads cdo
1112: WHERE cdo.department_id = p_dept_id
1113: AND cdo.organization_id = p_org_id
1114: AND cdo.cost_type_id = p_pac_ct_id
1115: AND cdo.basis_type IN (3,4)
1135: wt.primary_quantity*cdo.rate_or_amount applied_value
1136: FROM
1137: wip_transactions wt,
1138: wip_transaction_accounts wta,
1139: cst_department_overheads cdo
1140: WHERE wt.wip_entity_id = p_entity_id
1141: AND wt.transaction_date BETWEEN TRUNC(p_start_date)
1142: AND (TRUNC(p_end_date) + 0.99999)
1143: AND wt.transaction_type = 2 -- MBO