APPS.CST_JOBCLOSEVAR_GRP dependencies on WIP_PERIOD_BALANCES

Line 272: wip_period_balances wpb,

268: p_prg_appl_id,
269: p_prg_id,
270: sysdate
271: FROM wip_cost_txn_interface wcti,
272: wip_period_balances wpb,
273: wip_discrete_jobs wdj,
274: cst_cost_elements cce
275: WHERE wcti.group_id = p_wcti_group_id
276: AND wcti.wip_entity_id = wpb.wip_entity_id

Line 395: wip_period_balances wpb,

391: p_prg_appl_id,
392: p_prg_id,
393: SYSDATE
394: FROM wip_cost_txn_interface wcti,
395: wip_period_balances wpb,
396: wip_discrete_jobs wdj,
397: cst_cost_elements cce
398: WHERE wcti.group_id = p_wcti_group_id
399: AND cce.cost_element_id <> 2

Line 452: UPDATE wip_period_balances wpb

448: | times in the same period if the job were closed repeatedly. |
449: +------------------------------------------------------------------------*/
450: l_stmt_num := 50;
451:
452: UPDATE wip_period_balances wpb
453: SET (last_updated_by,
454: last_update_date,
455: last_update_login,
456: pl_material_var,

Line 520: FROM wip_period_balances wpb2

516: - NVL(tl_overhead_out,0)
517: - DECODE(wpb2.acct_period_id,
518: wpb.acct_period_id,0,
519: NVL(tl_overhead_var,0)))
520: FROM wip_period_balances wpb2
521: WHERE wpb2.wip_entity_id = wpb.wip_entity_id
522: AND wpb2.acct_period_id <= wpb.acct_period_id)
523: WHERE (wpb.acct_period_id,
524: wpb.wip_entity_id)

Line 603: DELETE FROM WIP_PERIOD_BALANCES wpb

599: | period starting date > job close date) |
600: +------------------------------------------------------------------------*/
601: l_stmt_num := 80;
602:
603: DELETE FROM WIP_PERIOD_BALANCES wpb
604: WHERE (wpb.acct_period_id,
605: wpb.wip_entity_id)
606: IN
607: (SELECT a.acct_period_id,