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: --{BUG#13072387
276: , org_acct_periods ocpf

Line 406: wip_period_balances wpb,

402: p_prg_appl_id,
403: p_prg_id,
404: SYSDATE
405: FROM wip_cost_txn_interface wcti,
406: wip_period_balances wpb,
407: wip_discrete_jobs wdj,
408: cst_cost_elements cce
409: --{BUG#13072387
410: , org_acct_periods ocpf

Line 474: UPDATE wip_period_balances wpb

470: | times in the same period if the job were closed repeatedly. |
471: +------------------------------------------------------------------------*/
472: l_stmt_num := 50;
473:
474: UPDATE wip_period_balances wpb
475: SET (last_updated_by,
476: last_update_date,
477: last_update_login,
478: pl_material_var,

Line 542: FROM wip_period_balances wpb2

538: - NVL(tl_overhead_out,0)
539: - DECODE(wpb2.acct_period_id,
540: wpb.acct_period_id,0,
541: NVL(tl_overhead_var,0)))
542: FROM wip_period_balances wpb2
543: --{BUG#13072387
544: , org_acct_periods ocpf
545: , org_acct_periods ocpt
546: --}

Line 637: DELETE FROM WIP_PERIOD_BALANCES wpb

633: | period starting date > job close date) |
634: +------------------------------------------------------------------------*/
635: l_stmt_num := 80;
636:
637: DELETE FROM WIP_PERIOD_BALANCES wpb
638: WHERE (wpb.acct_period_id,
639: wpb.wip_entity_id)
640: IN
641: (SELECT a.acct_period_id,