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 2847: WIP_PERIOD_BALANCES WPB

2843: i_prog_id,
2844: SYSDATE
2845: FROM
2846: CST_COST_ELEMENTS CCE,
2847: WIP_PERIOD_BALANCES WPB
2848: WHERE
2849: WPB.WIP_ENTITY_ID = I_WIP_ENTITY_ID AND
2850: WPB.ORGANIZATION_ID = I_ORG_ID AND
2851: CCE.COST_ELEMENT_ID <> 2

Line 2909: WIP_PERIOD_BALANCES WPB

2905: i_prog_id,
2906: SYSDATE
2907: FROM
2908: CST_COST_ELEMENTS CCE,
2909: WIP_PERIOD_BALANCES WPB
2910: WHERE
2911: WPB.WIP_ENTITY_ID = I_WIP_ENTITY_ID AND
2912: WPB.ORGANIZATION_ID = I_ORG_ID
2913: GROUP BY CCE.COST_ELEMENT_ID, WPB.WIP_ENTITY_ID

Line 3491: UPDATE wip_period_balances wpb

3487: DELETE wip_cost_txn_interface
3488: WHERE transaction_id = i_wcti_txn_id;
3489:
3490: stmt_num := 500;
3491: UPDATE wip_period_balances wpb
3492: SET
3493: (last_update_date,
3494: last_updated_by,
3495: last_update_login,