APPS.JA_CN_FA_BI_EXPORT_PKG dependencies on JA_CN_CFS_DATA_CLT_PKG

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

103: SYSDATE) OR fdh.date_ineffective IS NULL)
104: AND EXISTS
105: (SELECT jclllbg.bal_seg_value
106: FROM ja_cn_ledger_le_bsv_gt jclllbg
107: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =
108: jclllbg.bal_seg_value
109: AND jclllbg.ledger_id = pn_ledger_id
110: AND jclllbg.legal_entity_id = pn_legal_entity_id))
111: ORDER BY fcb.asset_cost_acct;

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

151: SYSDATE) OR fdh.date_ineffective IS NULL)
152: AND EXISTS
153: (SELECT jclllbg.bal_seg_value
154: FROM ja_cn_ledger_le_bsv_gt jclllbg
155: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =
156: jclllbg.bal_seg_value
157: AND jclllbg.ledger_id = pn_ledger_id
158: AND jclllbg.legal_entity_id = pn_legal_entity_id))
159: ORDER BY fcb.impair_reserve_acct;

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

199: SYSDATE) OR fdh.date_ineffective IS NULL)
200: AND EXISTS
201: (SELECT jclllbg.bal_seg_value
202: FROM ja_cn_ledger_le_bsv_gt jclllbg
203: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(fdh.code_combination_id) =
204: jclllbg.bal_seg_value
205: AND jclllbg.ledger_id = pn_ledger_id
206: AND jclllbg.legal_entity_id = pn_legal_entity_id))
207: ORDER BY fcb.deprn_reserve_acct;