APPS.FUN_BAL_PKG dependencies on GL_LEDGERS

Line 538: FROM gl_ledgers ledgers

534: --ASLAI_INIT_01
535: UPDATE fun_bal_headers_gt headers
536: SET (bal_seg_column_name, chart_of_accounts_id) =
537: (SELECT bal_seg_column_name, chart_of_accounts_id
538: FROM gl_ledgers ledgers
539: WHERE headers.ledger_id = ledgers.ledger_id);
540:
541: UPDATE fun_bal_headers_gt headers
542: SET bal_seg_column_number = get_segment_index ( headers.chart_of_accounts_id,

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

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

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

703: -- Bug 3310453
704: INSERT INTO fun_bal_errors_gt(error_code, group_id, bal_seg_val)
705: SELECT 'FUN_BSV_INVALID', main.group_id, main.bal_seg_val
706: FROM (SELECT DISTINCT hdrs.group_id, lines.bal_seg_val, hdrs.gl_date, hdrs.ledger_id
707: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines, gl_ledgers ledger
708: WHERE hdrs.group_id = lines.group_id
709: AND hdrs.ledger_id = ledger.ledger_id(+)
710: AND ledger.bal_seg_value_option_code = 'I') main
711: WHERE main.bal_seg_val NOT IN (SELECT vals.segment_value

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

735:
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(+)

Line 811: FROM gl_ledgers ledgers

807: error_code = 'FUN_INTRA_OVERRIDE_BSV_ERROR'
808: WHERE hdrs.status = 'OK'
809: AND hdrs.clearing_bsv IS NOT NULL
810: AND NOT (hdrs.ledger_id IN (SELECT ledgers.ledger_id
811: FROM gl_ledgers ledgers
812: WHERE ledgers.bal_seg_value_option_code = 'A')
813: OR
814: hdrs.clearing_bsv IN (SELECT vals.segment_value
815: FROM gl_ledger_le_bsv_specific_v vals

Line 2214: gl_ledgers ledger

2210: DECODE(le_bsv_map.le_id, -99, NULL, le_bsv_map.le_id),
2211: le_bsv_map.clearing_bsv,
2212: le_bsv_map.driving_dr_bsv, le_bsv_map.driving_cr_bsv
2213: FROM fun_bal_le_bsv_map_gt le_bsv_map,
2214: gl_ledgers ledger
2215: WHERE le_bsv_map.clearing_bsv IS NOT NULL
2216: AND ledger.ledger_id = le_bsv_map.ledger_id
2217: AND ledger.bal_seg_value_option_code = 'I'
2218: AND NOT EXISTS