APPS.JA_CN_JE_EXPORT_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 210: FROM ja_cn_ledger_le_bsv_gt

206: @AND_CONDITION
207: AND ledger_id = :5
208: AND company_segment IN
209: (SELECT bal_seg_value
210: FROM ja_cn_ledger_le_bsv_gt
211: WHERE legal_entity_id = :6)
212: GROUP BY je_header_id,
213: voucher_number,
214: account_segment,

Line 266: FROM ja_cn_ledger_le_bsv_gt

262: @AND_CONDITION
263: AND jcjl.ledger_id = :5
264: AND jcjl.company_segment IN
265: (SELECT bal_seg_value
266: FROM ja_cn_ledger_le_bsv_gt
267: WHERE legal_entity_id = :6)
268: GROUP BY jcjl.je_header_id,
269: jcjl.voucher_number,
270: jcjl.account_segment,

Line 305: FROM ja_cn_ledger_le_bsv_gt

301: SELECT DISTINCT account_segment
302: FROM ja_cn_journal_lines
303: WHERE company_segment IN
304: (SELECT bal_seg_value
305: FROM ja_cn_ledger_le_bsv_gt
306: WHERE legal_entity_id = pn_legal_entity_id
307: AND chart_of_accounts_id = pn_coa_id)
308: AND period_name IN
309: (SELECT period_name

Line 366: --Populate balancing segment values to table ja_cn_ledger_le_bsv_gt

362: 'pv_period_from=' || pv_period_from || ',' ||
363: 'pv_period_to=' || pv_period_to);
364:
365: FND_FILE.put_line(FND_FILE.log, lv_sql_stmt4insert_j_line);
366: --Populate balancing segment values to table ja_cn_ledger_le_bsv_gt
367: DELETE FROM JA_CN_LEDGER_LE_BSV_GT;
368: COMMIT;
369: IF Ja_Cn_Utility.Populate_Ledger_Le_Bsv_Gt(pn_Ledger_Id,pn_legal_entity_id) <> 'S'
370: THEN

Line 367: DELETE FROM JA_CN_LEDGER_LE_BSV_GT;

363: 'pv_period_to=' || pv_period_to);
364:
365: FND_FILE.put_line(FND_FILE.log, lv_sql_stmt4insert_j_line);
366: --Populate balancing segment values to table ja_cn_ledger_le_bsv_gt
367: DELETE FROM JA_CN_LEDGER_LE_BSV_GT;
368: COMMIT;
369: IF Ja_Cn_Utility.Populate_Ledger_Le_Bsv_Gt(pn_Ledger_Id,pn_legal_entity_id) <> 'S'
370: THEN
371: RETURN;