1082: );
1083:
1084: CURSOR c_fetch_overhead_rate(cp_organization_id in number, cp_item_id in number) IS
1085: SELECT a.resource_id, a.usage_rate_or_amount, b.absorption_account
1086: FROM cst_item_cost_details a, bom_resources b
1087: WHERE a.resource_id = b.resource_id
1088: AND a.organization_id = cp_organization_id
1089: AND a.inventory_item_id = cp_item_id
1090: AND a.cost_element_id = 2 --Indicates Material OverHead