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 300: INSERT INTO wip_transaction_accounts

296: | across all accounting periods. |
297: +------------------------------------------------------------------------*/
298: l_stmt_num := 40;
299:
300: INSERT INTO wip_transaction_accounts
301: (transaction_id,
302: reference_account,
303: last_update_date,
304: last_updated_by,

Line 419: UPDATE WIP_TRANSACTION_ACCOUNTS

415: CLOSE c_transactions;
416:
417: l_stmt_num := 46;
418: FORALL l_index in l_transaction_t.FIRST..l_transaction_t.LAST
419: UPDATE WIP_TRANSACTION_ACCOUNTS
420: SET WIP_SUB_LEDGER_ID = CST_WIP_SUB_LEDGER_ID_S.NEXTVAL
421: WHERE TRANSACTION_ID = l_transaction_t(l_index);
422:
423: l_stmt_num := 47;