APPS.FUN_BAL_PKG dependencies on GL_LEDGER_CONFIGURATIONS

Line 681: gl_ledger_configurations config

677: /* Replaced by sql below from performance review
678: INSERT INTO fun_bal_le_bsv_map_gt(group_id, ledger_id, bal_seg_val, gl_date)
679: SELECT DISTINCT hdrs.group_id, hdrs.ledger_id, lines.bal_seg_val, hdrs.gl_date
680: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger,
681: gl_ledger_configurations config
682: WHERE hdrs.group_id = lines.group_id
683: AND hdrs.ledger_id = ledger.ledger_id
684: AND ledger.configuration_id = config.configuration_id
685: AND ledger.bal_seg_value_option_code = 'I';

Line 740: gl_ledger_configurations config

736: INSERT INTO fun_bal_le_bsv_map_gt(group_id, ledger_id, bal_seg_val, gl_date, le_id)
737: SELECT main.group_id, main.ledger_id, main.bal_seg_val, main.gl_date, NVL(vals.legal_entity_id, -99)
738: FROM (SELECT DISTINCT hdrs.group_id, hdrs.ledger_id, lines.bal_seg_val, hdrs.gl_date
739: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger,
740: gl_ledger_configurations config
741: WHERE hdrs.status = 'OK' -- Bug 3310453
742: AND hdrs.group_id = lines.group_id
743: AND hdrs.ledger_id = ledger.ledger_id(+)
744: AND ledger.configuration_id = config.configuration_id