DBA Data[Home] [Help]

APPS.JA_CN_FA_ADI_EXPORT_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 118: FROM ja_cn_ledger_le_bsv_gt jclllbg

114: -- WHERE legal_entity_id = ln_legal_entity_id
115: -- AND ledger_id = ln_ledger_id)
116: AND EXISTS
117: (SELECT jclllbg.bal_seg_value
118: FROM ja_cn_ledger_le_bsv_gt jclllbg
119: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =
120: jclllbg.bal_seg_value
121: AND jclllbg.Ledger_Id = ln_ledger_id
122: AND jclllbg.Legal_Entity_Id = ln_legal_entity_id)

Line 275: FROM ja_cn_ledger_le_bsv_gt jclllbg

271: AND (fdh.date_ineffective > nvl(ld_dp_close_date, SYSDATE) OR
272: fdh.date_ineffective IS NULL)
273: AND EXISTS
274: (SELECT jclllbg.bal_seg_value
275: FROM ja_cn_ledger_le_bsv_gt jclllbg
276: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =
277: jclllbg.bal_seg_value
278: AND jclllbg.Ledger_Id = pn_ledger_id
279: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id);