DBA Data[Home] [Help]

APPS.JA_CN_FA_ACS_EXPORT_PKG dependencies on JA_CN_CFS_DATA_CLT_PKG

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

143: SYSDATE) OR fdh.date_ineffective IS NULL)
144: AND EXISTS
145: (SELECT jclllbg.bal_seg_value
146: FROM ja_cn_ledger_le_bsv_gt jclllbg
147: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =
148: jclllbg.bal_seg_value
149: AND jclllbg.ledger_id = pn_ledger_id
150: AND jclllbg.legal_entity_id = pn_legal_entity_id))
151: AND fcbk.category_id = fcb.category_id;