APPS.CST_PAC_WIP_VALUE_REPORT_PVT dependencies on WIP_PAC_PERIOD_BALANCES

Line 497: FROM wip_pac_period_balances wppb

493: sum( nvl(tl_resource_var ,0) + nvl(pl_resource_var, 0)) resource_var,
494: sum( nvl(tl_outside_processing_var ,0) + nvl(pl_outside_processing_var,0)) osp_var,
495: sum( nvl(tl_overhead_var,0) + nvl(pl_overhead_var, 0)) overhead_var
496:
497: FROM wip_pac_period_balances wppb
498: WHERE wppb.pac_period_id = p_pac_period_id
499: AND wppb.cost_type_id = p_cost_type_id
500: AND wppb.cost_group_id = p_cost_group_id
501: GROUP BY wppb.wip_entity_id,

Line 661: FROM wip_pac_period_balances wppb

657: l_prev_material_ovhd_var,
658: l_prev_resource_var,
659: l_prev_osp_var,
660: l_prev_overhead_var
661: FROM wip_pac_period_balances wppb
662: WHERE wppb.pac_period_id = l_prev_period_id
663: AND wppb.wip_entity_id = temp_rec.wip_entity_id
664: AND nvl(wppb.line_id,-99) = nvl(temp_rec.line_id,-99)
665: AND wppb.cost_type_id = p_cost_type_id;