APPS.CSTPOYLD dependencies on WIP_PERIOD_BALANCES

Line 1047: -- Update WIP_PERIOD_BALANCEs --

1043: END;
1044:
1045: END LOOP opseq;
1046: ---------------------------------------------------------
1047: -- Update WIP_PERIOD_BALANCEs --
1048: ---------------------------------------------------------
1049:
1050:
1051: /* Update WOY if x_tl_scrap_in or x_tl_scrap_out <> 0 */

Line 1054: UPDATE WIP_PERIOD_BALANCES

1050:
1051: /* Update WOY if x_tl_scrap_in or x_tl_scrap_out <> 0 */
1052: IF (x_tl_scrap_in <> 0 OR x_tl_scrap_out <> 0) THEN
1053: x_statement := 130;
1054: UPDATE WIP_PERIOD_BALANCES
1055: SET tl_scrap_in = NVL(tl_scrap_in, 0) + x_tl_scrap_in,
1056: tl_scrap_out = NVL(tl_scrap_out, 0) + x_tl_scrap_out,
1057: last_update_date = x_sysdate,
1058: last_updated_by = x_last_updated_by,

Line 1238: WIP_PERIOD_BALANCES

1234: x_tl_scrap_in,
1235: x_tl_scrap_out,
1236: x_tl_scrap_var
1237: FROM
1238: WIP_PERIOD_BALANCES
1239: WHERE
1240: wip_entity_id=rec_wip_entity.wip_entity_id
1241: AND organization_id=rec_wip_entity.organization_id
1242: AND acct_period_id <= rec_wip_entity.acct_period_id;

Line 1361: -- Update WIP_PERIOD_BALANCES --

1357:
1358: END IF;
1359:
1360: ---------------------------------------------------------
1361: -- Update WIP_PERIOD_BALANCES --
1362: ---------------------------------------------------------
1363:
1364:
1365: UPDATE WIP_PERIOD_BALANCES wpb

Line 1365: UPDATE WIP_PERIOD_BALANCES wpb

1361: -- Update WIP_PERIOD_BALANCES --
1362: ---------------------------------------------------------
1363:
1364:
1365: UPDATE WIP_PERIOD_BALANCES wpb
1366: SET
1367: TL_SCRAP_VAR =
1368: (SELECT SUM( NVL(TL_SCRAP_IN,0)
1369: - NVL(TL_SCRAP_OUT,0)

Line 1372: FROM WIP_PERIOD_BALANCES wpb2

1368: (SELECT SUM( NVL(TL_SCRAP_IN,0)
1369: - NVL(TL_SCRAP_OUT,0)
1370: - decode(wpb2.acct_period_id,wpb.acct_period_id,0,
1371: NVL(TL_SCRAP_VAR,0)))
1372: FROM WIP_PERIOD_BALANCES wpb2
1373: WHERE wpb2.wip_entity_id = wpb.wip_entity_id
1374: AND wpb2.acct_period_id <= wpb.acct_period_id),
1375: last_update_date = sysdate,
1376: last_updated_by = i_user_id,