APPS.CSTPACWC dependencies on WIP_PERIOD_BALANCES

Line 730: | final completions are computed off wip_period_balances.

726: | cost type, and this is a final completion.
727: | We also need to include the case where the job has
728: | SYSTEM derived costs but has no bill/rtg ==> regular
729: | completions are costed from the valuation cost type and
730: | final completions are computed off wip_period_balances.
731: |-------------------------------------------------------*/
732:
733:
734: ELSIF (i_final_comp_flag = 'Y'

Line 803: WIP_PERIOD_BALANCES WPB

799: i_prog_id,
800: SYSDATE
801: FROM
802: CST_COST_ELEMENTS CCE,
803: WIP_PERIOD_BALANCES WPB
804: WHERE
805: WPB.WIP_ENTITY_ID = I_WIP_ENTITY_ID AND
806: WPB.ORGANIZATION_ID = I_ORG_ID AND
807: CCE.COST_ELEMENT_ID <> 2

Line 865: WIP_PERIOD_BALANCES WPB

861: i_prog_id,
862: SYSDATE
863: FROM
864: CST_COST_ELEMENTS CCE,
865: WIP_PERIOD_BALANCES WPB
866: WHERE
867: WPB.WIP_ENTITY_ID = I_WIP_ENTITY_ID AND
868: WPB.ORGANIZATION_ID = I_ORG_ID
869: GROUP BY CCE.COST_ELEMENT_ID, WPB.WIP_ENTITY_ID

Line 2723: WIP_PERIOD_BALANCES WPB

2719: i_prog_id,
2720: SYSDATE
2721: FROM
2722: CST_COST_ELEMENTS CCE,
2723: WIP_PERIOD_BALANCES WPB
2724: WHERE
2725: WPB.WIP_ENTITY_ID = I_WIP_ENTITY_ID AND
2726: WPB.ORGANIZATION_ID = I_ORG_ID AND
2727: CCE.COST_ELEMENT_ID <> 2

Line 2779: WIP_PERIOD_BALANCES WPB

2775: i_prog_id,
2776: SYSDATE
2777: FROM
2778: CST_COST_ELEMENTS CCE,
2779: WIP_PERIOD_BALANCES WPB
2780: WHERE
2781: WPB.WIP_ENTITY_ID = I_WIP_ENTITY_ID AND
2782: WPB.ORGANIZATION_ID = I_ORG_ID
2783: GROUP BY CCE.COST_ELEMENT_ID, WPB.WIP_ENTITY_ID;

Line 3326: UPDATE wip_period_balances wpb

3322: DELETE wip_cost_txn_interface
3323: WHERE transaction_id = i_wcti_txn_id;
3324:
3325: stmt_num := 500;
3326: UPDATE wip_period_balances wpb
3327: SET
3328: (last_update_date,
3329: last_updated_by,
3330: last_update_login,