DBA Data[Home] [Help]

APPS.JA_CN_FA_MM_EXPORT_PKG dependencies on JA_CN_CFS_DATA_CLT_PKG

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

90: OR fdh.date_ineffective IS NULL)
91: AND EXISTS
92: (SELECT jclllbg.bal_seg_value
93: FROM ja_cn_ledger_le_bsv_gt jclllbg
94: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =
95: jclllbg.bal_seg_value
96: AND jclllbg.Ledger_Id = pn_ledger_id
97: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id)
98: AND greatest(greatest(fdp.calendar_period_open_date,