eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_CFS_REPORT_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 120: FROM JA_CN_LEDGER_LE_BSV_GT

116: AND JCA.GL_DATE <= GP2.END_DATE
117: AND ((P_BSV IS NOT NULL AND JCA.BALANCING_SEGMENT = P_BSV) OR
118: (P_BSV IS NULL AND JCA.BALANCING_SEGMENT IN
119: (SELECT BAL_SEG_VALUE
120: FROM JA_CN_LEDGER_LE_BSV_GT
121: WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
122: AND LEDGER_ID = P_LEDGER_ID)))
123: AND JCCA.DETAILED_CFS_ITEM = JCA.DETAILED_CFS_ITEM
124: AND JCCA.CHART_OF_ACCOUNTS_ID = P_CHART_OF_ACCOUNTS_ID

Line 150: FROM JA_CN_LEDGER_LE_BSV_GT

146: AND JCA.PERIOD_NAME = XX_PERIOD_NAME --****
147: AND ((P_BSV IS NOT NULL AND JCA.BALANCING_SEGMENT = P_BSV) OR
148: (P_BSV IS NULL AND JCA.BALANCING_SEGMENT IN
149: (SELECT BAL_SEG_VALUE
150: FROM JA_CN_LEDGER_LE_BSV_GT
151: WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
152: AND LEDGER_ID = P_LEDGER_ID)))
153: AND JCCA.DETAILED_CFS_ITEM = JCA.DETAILED_CFS_ITEM
154: AND JCCA.CHART_OF_ACCOUNTS_ID = P_CHART_OF_ACCOUNTS_ID

Line 186: FROM JA_CN_LEDGER_LE_BSV_GT

182: AND JCA.PERIOD_NAME = XX_PERIOD_NAME --****
183: AND ((P_BSV IS NOT NULL AND JCA.BALANCING_SEGMENT = P_BSV) OR
184: (P_BSV IS NULL AND JCA.BALANCING_SEGMENT IN
185: (SELECT BAL_SEG_VALUE
186: FROM JA_CN_LEDGER_LE_BSV_GT
187: WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
188: AND LEDGER_ID = P_LEDGER_ID)))
189: AND JCCA.DETAILED_CFS_ITEM = JCA.DETAILED_CFS_ITEM
190: AND JCCA.CHART_OF_ACCOUNTS_ID = P_CHART_OF_ACCOUNTS_ID

Line 229: FROM JA_CN_LEDGER_LE_BSV_GT

225: AND JCA.PERIOD_NAME = XX_PERIOD_NAME --****
226: AND ((P_BSV IS NOT NULL AND JCA.BALANCING_SEGMENT = P_BSV) OR
227: (P_BSV IS NULL AND JCA.BALANCING_SEGMENT IN
228: (SELECT BAL_SEG_VALUE
229: FROM JA_CN_LEDGER_LE_BSV_GT
230: WHERE LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
231: AND LEDGER_ID = P_LEDGER_ID)))
232: AND JCCA.DETAILED_CFS_ITEM = JCA.DETAILED_CFS_ITEM
233: AND JCCA.CHART_OF_ACCOUNTS_ID = P_CHART_OF_ACCOUNTS_ID

Line 311: FROM JA_CN_LEDGER_LE_BSV_GT;

307: END IF; --(l_proc_level >= l_dbg_level)
308:
309: --fix bug 7488223 add begin
310: DELETE
311: FROM JA_CN_LEDGER_LE_BSV_GT;
312: COMMIT ;
313: --
314: --ja_cn_utility_pkg.populate_ledger_le_bsv_gt( P_LEDGER_ID,P_LE_ID);
315: