DBA Data[Home] [Help]

APPS.JA_CN_FA_BI_EXPORT_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 106: FROM ja_cn_ledger_le_bsv_gt jclllbg

102: AND fdp.period_close_date IS NOT NULL),
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))

Line 154: FROM ja_cn_ledger_le_bsv_gt jclllbg

150: AND fdp.period_close_date IS NOT NULL),
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))

Line 202: FROM ja_cn_ledger_le_bsv_gt jclllbg

198: AND fdp.period_close_date IS NOT NULL),
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))