DBA Data[Home] [Help]

APPS.JA_CN_HISDATA_MIG_PKG dependencies on JA_CN_CFS_ACTIVITIES_ALL

Line 240: -- JA_CN_JOURNAL_LINES to ja_cn_cfs_activities_all for the SLA transaction

236: --
237: -- DESCRIPTION:
238: --
239: -- This procedure is used to migrate the header id and line number from
240: -- JA_CN_JOURNAL_LINES to ja_cn_cfs_activities_all for the SLA transaction
241: -- type.
242: --
243: --
244: -- PARAMETERS:

Line 290: UPDATE ja_cn_cfs_activities_all jcca

286: 'pv_period_name=' || pv_period_name || ',' ||
287: 'pn_ledger_id=' || pn_ledger_id || ',' ||
288: 'pn_legal_entitliy_id=' || pn_legal_entitliy_id);
289: BEGIN
290: UPDATE ja_cn_cfs_activities_all jcca
291: SET jcca.je_header_id =
292: (SELECT DISTINCT jcjl.je_header_id
293: FROM JA_CN_JOURNAL_LINES jcjl,
294: Gl_Je_Headers Jeh,