DBA Data[Home] [Help]

APPS.CSTPPWRO dependencies on CST_DEPARTMENT_OVERHEADS

Line 1112: cst_department_overheads cdo

1108: p_res_value) applied_value,
1109: decode(cdo.basis_type, 3, p_res_units,
1110: p_res_value) basis_units
1111: FROM cst_resource_overheads cro,
1112: cst_department_overheads cdo
1113: WHERE cdo.department_id = p_dept_id
1114: AND cdo.organization_id = p_org_id
1115: AND cdo.cost_type_id = p_pac_ct_id
1116: AND cdo.basis_type IN (3,4)

Line 1140: cst_department_overheads cdo

1136: wt.primary_quantity*cdo.rate_or_amount applied_value
1137: FROM
1138: wip_transactions wt,
1139: wip_transaction_accounts wta,
1140: cst_department_overheads cdo
1141: WHERE wt.wip_entity_id = p_entity_id
1142: AND wt.transaction_date BETWEEN TRUNC(p_start_date)
1143: AND (TRUNC(p_end_date) + 0.99999)
1144: AND wt.transaction_type = 2 -- MBO