APPS.CSTPPWCL dependencies on WIP_PAC_PERIOD_BALANCES

Line 68: FROM wip_pac_period_balances wppb

64: AND we.wip_entity_id = wt.wip_entity_id
65: AND we.entity_type <> 2 -- Not a rep schedule
66: AND EXISTS (
67: SELECT 'X'
68: FROM wip_pac_period_balances wppb
69: WHERE wppb.pac_period_id = p_pac_period_id
70: AND wppb.cost_group_id = p_cost_group_id
71: AND wppb.wip_entity_id = wt.wip_entity_id
72: )

Line 90: FROM wip_pac_period_balances wppb

86: SELECT wppb.wip_entity_id entity_id,
87: wppb.cost_group_id cost_group_id,
88: wppb.line_id line_id,
89: wppb.operation_seq_num op_seq_num
90: FROM wip_pac_period_balances wppb
91: WHERE wppb.pac_period_id = p_pac_period_id
92: AND wppb.cost_group_id = p_cost_group_id
93: AND wppb.wip_entity_type = 2; -- Rep. Svhedule
94:

Line 120: FROM wip_pac_period_balances wppb

116: SUM(NVL(wppb.pl_overhead_out,0)) +
117: SUM(NVL(wppb.tl_resource_out,0)) +
118: SUM(NVL(wppb.tl_outside_processing_out,0)) +
119: SUM(NVL(wppb.tl_overhead_out,0)) value_out
120: FROM wip_pac_period_balances wppb
121: WHERE wppb.pac_period_id = p_pac_period_id
122: AND wppb.cost_group_id = p_cost_group_id
123: AND EXISTS
124: ( SELECT 'X'

Line 227: FROM wip_pac_period_balances wppb

223: p_prog_app_id,
224: p_prog_id,
225: SYSDATE,
226: p_login_id
227: FROM wip_pac_period_balances wppb
228: WHERE wppb.pac_period_id = p_pac_period_id
229: AND wppb.cost_group_id = p_cost_group_id
230: AND wppb.wip_entity_id = c_jobclose_rec.entity_id;
231:

Line 278: FROM wip_pac_period_balances wppb

274: p_prog_app_id,
275: p_prog_id,
276: SYSDATE,
277: p_login_id
278: FROM wip_pac_period_balances wppb
279: WHERE wppb.pac_period_id = p_pac_period_id
280: AND wppb.cost_group_id = p_cost_group_id
281: AND wppb.wip_entity_id = c_jobclose_rec.entity_id;
282:

Line 329: FROM wip_pac_period_balances wppb

325: p_prog_app_id,
326: p_prog_id,
327: SYSDATE,
328: p_login_id
329: FROM wip_pac_period_balances wppb
330: WHERE wppb.pac_period_id = p_pac_period_id
331: AND wppb.cost_group_id = p_cost_group_id
332: AND wppb.wip_entity_id = c_jobclose_rec.entity_id;
333:

Line 380: FROM wip_pac_period_balances wppb

376: p_prog_app_id,
377: p_prog_id,
378: SYSDATE,
379: p_login_id
380: FROM wip_pac_period_balances wppb
381: WHERE wppb.pac_period_id = p_pac_period_id
382: AND wppb.cost_group_id = p_cost_group_id
383: AND wppb.wip_entity_id = c_jobclose_rec.entity_id;
384:

Line 431: FROM wip_pac_period_balances wppb

427: p_prog_app_id,
428: p_prog_id,
429: SYSDATE,
430: p_login_id
431: FROM wip_pac_period_balances wppb
432: WHERE wppb.pac_period_id = p_pac_period_id
433: AND wppb.cost_group_id = p_cost_group_id
434: AND wppb.wip_entity_id = c_jobclose_rec.entity_id;
435:

Line 482: FROM wip_pac_period_balances wppb

478: p_prog_app_id,
479: p_prog_id,
480: SYSDATE,
481: p_login_id
482: FROM wip_pac_period_balances wppb
483: WHERE wppb.pac_period_id = p_pac_period_id
484: AND wppb.cost_group_id = p_cost_group_id
485: AND wppb.wip_entity_id = c_jobclose_rec.entity_id;
486:

Line 533: FROM wip_pac_period_balances wppb

529: p_prog_app_id,
530: p_prog_id,
531: SYSDATE,
532: p_login_id
533: FROM wip_pac_period_balances wppb
534: WHERE wppb.pac_period_id = p_pac_period_id
535: AND wppb.cost_group_id = p_cost_group_id
536: AND wppb.wip_entity_id = c_jobclose_rec.entity_id;
537:

Line 584: FROM wip_pac_period_balances wppb

580: p_prog_app_id,
581: p_prog_id,
582: SYSDATE,
583: p_login_id
584: FROM wip_pac_period_balances wppb
585: WHERE wppb.pac_period_id = p_pac_period_id
586: AND wppb.cost_group_id = p_cost_group_id
587: AND wppb.wip_entity_id = c_jobclose_rec.entity_id;
588:

Line 735: UPDATE wip_pac_period_balances wppb

731: -- So only left value in the Job should be flushed to TEMP Variance
732: --------------------------------------------------------------------------------------
733: l_stmt_num := 5;
734:
735: UPDATE wip_pac_period_balances wppb
736: SET tl_resource_var = NVL(tl_resource_in,0)
737: - NVL(tl_resource_out,0),
738: tl_outside_processing_var = NVL(tl_outside_processing_in,0)
739: - NVL(tl_outside_processing_out,0),