DBA Data[Home] [Help]

APPS.CST_JOBCLOSEVAR_GRP dependencies on WIP_TRANSACTION_ACCOUNTS

Line 176: INSERT INTO wip_transaction_accounts

172: | across all accounting periods. |
173: +------------------------------------------------------------------------*/
174: l_stmt_num := 30;
175:
176: INSERT INTO wip_transaction_accounts
177: (transaction_id,
178: reference_account,
179: last_update_date,
180: last_updated_by,

Line 311: INSERT INTO wip_transaction_accounts

307: | across all accounting periods. |
308: +------------------------------------------------------------------------*/
309: l_stmt_num := 40;
310:
311: INSERT INTO wip_transaction_accounts
312: (transaction_id,
313: reference_account,
314: last_update_date,
315: last_updated_by,

Line 441: UPDATE WIP_TRANSACTION_ACCOUNTS

437: CLOSE c_transactions;
438:
439: l_stmt_num := 46;
440: FORALL l_index in l_transaction_t.FIRST..l_transaction_t.LAST
441: UPDATE WIP_TRANSACTION_ACCOUNTS
442: SET WIP_SUB_LEDGER_ID = CST_WIP_SUB_LEDGER_ID_S.NEXTVAL
443: WHERE TRANSACTION_ID = l_transaction_t(l_index);
444:
445: l_stmt_num := 47;