APPS.CSTPWPVR dependencies on WIP_TRANSACTION_ACCOUNTS

Line 23: FROM WIP_TRANSACTION_ACCOUNTS a2

19: my_rowid ROWID;
20: /* Commented for bug 12402436
21: cursor c1 is
22: SELECT a2.ROWID the_rowid
23: FROM WIP_TRANSACTION_ACCOUNTS a2
24: , WIP_COST_TXN_INTERFACE i
25: WHERE i.group_id = l_group_id
26: AND i.transaction_id = a2.transaction_id
27: AND a2.base_transaction_value = 0;*/

Line 157: INSERT INTO wip_transaction_accounts

153: /***************************************************************
154: * Elemental variance for wip valuation for expense/eam jobs
155: **************************************************************/
156: where_num := 120;
157: INSERT INTO wip_transaction_accounts
158: (TRANSACTION_ID, REFERENCE_ACCOUNT,
159: LAST_UPDATE_DATE, LAST_UPDATED_BY,
160: CREATION_DATE, CREATED_BY,
161: LAST_UPDATE_LOGIN, ORGANIZATION_ID,

Line 243: INSERT INTO wip_transaction_accounts

239: /***************************************************************
240: * Single level variance to variance account for expense/eam jobs
241: **************************************************************/
242: where_num := 140;
243: INSERT INTO wip_transaction_accounts
244: (TRANSACTION_ID, REFERENCE_ACCOUNT,
245: LAST_UPDATE_DATE, LAST_UPDATED_BY,
246: CREATION_DATE, CREATED_BY,
247: LAST_UPDATE_LOGIN, ORGANIZATION_ID,

Line 514: INSERT INTO wip_transaction_accounts

510: /***************************************************************
511: * Elemental variance for wip valuation for schedules
512: **************************************************************/
513: where_num := 220;
514: INSERT INTO wip_transaction_accounts
515: (TRANSACTION_ID, REFERENCE_ACCOUNT,
516: LAST_UPDATE_DATE, LAST_UPDATED_BY,
517: CREATION_DATE, CREATED_BY,
518: LAST_UPDATE_LOGIN, ORGANIZATION_ID,

Line 606: INSERT INTO wip_transaction_accounts

602: /***************************************************************
603: * Single level variance to variance account for schedules
604: **************************************************************/
605: where_num := 240;
606: INSERT INTO wip_transaction_accounts
607: (TRANSACTION_ID, REFERENCE_ACCOUNT,
608: LAST_UPDATE_DATE, LAST_UPDATED_BY,
609: CREATION_DATE, CREATED_BY,
610: LAST_UPDATE_LOGIN, ORGANIZATION_ID,

Line 810: DELETE FROM WIP_TRANSACTION_ACCOUNTS

806: OPEN c1;
807: LOOP
808: FETCH c1 into my_rowid;
809: EXIT WHEN c1%NOTFOUND;
810: DELETE FROM WIP_TRANSACTION_ACCOUNTS
811: WHERE ROWID = my_rowid;
812: END LOOP;
813: CLOSE c1;*/
814:

Line 819: UPDATE WIP_TRANSACTION_ACCOUNTS

815:
816: where_num := 560;
817:
818: /* Update WTA with WIP_SUB_LEDGER_ID */
819: UPDATE WIP_TRANSACTION_ACCOUNTS
820: SET WIP_SUB_LEDGER_ID = CST_WIP_SUB_LEDGER_ID_S.NEXTVAL
821: WHERE TRANSACTION_ID IN
822: ( SELECT TRANSACTION_ID
823: FROM WIP_COST_TXN_INTERFACE