DBA Data[Home] [Help]

APPS.JA_CN_FA_MI_EXPORT_PKG dependencies on JA_CN_CFS_DATA_CLT_PKG

Line 124: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =

120: -- AND ledger_id = ln_ledger_id)
121: AND EXISTS
122: (SELECT jclllbg.bal_seg_value
123: FROM ja_cn_ledger_le_bsv_gt jclllbg
124: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =
125: jclllbg.bal_seg_value
126: AND jclllbg.Ledger_Id = ln_ledger_id
127: AND jclllbg.Legal_Entity_Id = ln_legal_entity_id)
128: AND fbcs.set_of_books_id = ln_ledger_id

Line 237: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =

233: fdh.date_ineffective IS NULL)
234: AND EXISTS
235: (SELECT jclllbg.bal_seg_value
236: FROM ja_cn_ledger_le_bsv_gt jclllbg
237: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =
238: jclllbg.bal_seg_value
239: AND jclllbg.Ledger_Id = pn_ledger_id
240: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id);
241: -- calculate the assignment factor

Line 314: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =

310: fdh.date_ineffective IS NULL)
311: AND EXISTS
312: (SELECT jclllbg.bal_seg_value
313: FROM ja_cn_ledger_le_bsv_gt jclllbg
314: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =
315: jclllbg.bal_seg_value
316: AND jclllbg.Ledger_Id = pn_ledger_id
317: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id);
318: -- calculate the assignment factor, before the unit adjustment