APPS.FUN_BAL_PKG dependencies on GL_LEDGERS

Line 590: FROM gl_ledgers ledgers

586: --ASLAI_INIT_01
587: UPDATE fun_bal_headers_gt headers
588: SET (bal_seg_column_name, chart_of_accounts_id) =
589: (SELECT bal_seg_column_name, chart_of_accounts_id
590: FROM gl_ledgers ledgers
591: WHERE headers.ledger_id = ledgers.ledger_id);
592:
593: UPDATE fun_bal_headers_gt headers
594: SET bal_seg_column_number = get_segment_index ( headers.chart_of_accounts_id,

Line 603: from fun_bal_headers_gt headers, gl_ledgers gl

599: UPDATE fun_bal_lines_gt lines
600: SET entered_amt_dr = accounted_amt_dr,
601: entered_amt_cr = accounted_amt_cr,
602: entered_currency_code = (select gl.currency_code
603: from fun_bal_headers_gt headers, gl_ledgers gl
604: where gl.ledger_id = headers.ledger_id
605: and headers.group_id = lines.group_id),
606: exchange_date = null,
607: exchange_rate = null,

Line 750: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger,

746:
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

Line 777: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger

773: -- Bug 3310453
774: INSERT INTO fun_bal_errors_gt(error_code, group_id, bal_seg_val)
775: SELECT 'FUN_BSV_INVALID', main.group_id, main.bal_seg_val
776: FROM (SELECT DISTINCT hdrs.group_id, lines.bal_seg_val, hdrs.gl_date, hdrs.ledger_id
777: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger
778: WHERE hdrs.group_id = lines.group_id
779: AND hdrs.ledger_id = ledger.ledger_id(+)
780: AND ledger.bal_seg_value_option_code = 'I') main
781: WHERE main.bal_seg_val NOT IN (SELECT vals.segment_value

Line 813: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger,

809: INSERT INTO fun_bal_le_bsv_map_gt(group_id, ledger_id, bal_seg_val, gl_date, le_id, je_source_name, je_category_name)
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(+)

Line 884: FROM gl_ledgers ledgers

880: error_code = 'FUN_INTRA_OVERRIDE_BSV_ERROR'
881: WHERE hdrs.status = 'OK'
882: AND hdrs.clearing_bsv IS NOT NULL
883: AND NOT (hdrs.ledger_id IN (SELECT ledgers.ledger_id
884: FROM gl_ledgers ledgers
885: WHERE ledgers.bal_seg_value_option_code = 'A')
886: OR
887: hdrs.clearing_bsv IN (SELECT vals.segment_value
888: FROM gl_ledger_le_bsv_specific_v vals

Line 3187: gl_ledgers ledger

3183: DECODE(le_bsv_map.le_id, -99, NULL, le_bsv_map.le_id),
3184: le_bsv_map.clearing_bsv,
3185: le_bsv_map.driving_dr_bsv, le_bsv_map.driving_cr_bsv
3186: FROM fun_bal_le_bsv_map_gt le_bsv_map,
3187: gl_ledgers ledger
3188: WHERE le_bsv_map.clearing_bsv IS NOT NULL
3189: AND ledger.ledger_id = le_bsv_map.ledger_id
3190: AND ledger.bal_seg_value_option_code = 'I'
3191: AND NOT EXISTS