APPS.FUN_BAL_PKG dependencies on GL_LEDGER_CONFIGURATIONS

Line 751: gl_ledger_configurations config

747: /* Replaced by sql below from performance review
748: INSERT INTO fun_bal_le_bsv_map_gt(group_id, ledger_id, bal_seg_val, gl_date)
749: SELECT DISTINCT hdrs.group_id, hdrs.ledger_id, lines.bal_seg_val, hdrs.gl_date
750: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger,
751: gl_ledger_configurations config
752: WHERE hdrs.group_id = lines.group_id
753: AND hdrs.ledger_id = ledger.ledger_id
754: AND ledger.configuration_id = config.configuration_id
755: AND ledger.bal_seg_value_option_code = 'I';

Line 814: gl_ledger_configurations config

810: SELECT main.group_id, main.ledger_id, main.bal_seg_val, main.gl_date, NVL(vals.legal_entity_id, -99),
811: main.je_source_name, main.je_category_name
812: FROM (SELECT DISTINCT hdrs.group_id, hdrs.ledger_id, lines.bal_seg_val, hdrs.gl_date, hdrs.je_source_name, hdrs.je_category_name
813: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger,
814: gl_ledger_configurations config
815: WHERE hdrs.status = 'OK' -- Bug 3310453
816: AND hdrs.group_id = lines.group_id
817: AND hdrs.ledger_id = ledger.ledger_id(+)
818: AND ledger.configuration_id = config.configuration_id