eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_BAL_PKG dependencies on FUN_BAL_HEADERS_GT

Line 76: FROM fun_bal_headers_gt headers

72: rows_processed int;
73: l_bal_seg_column_name VARCHAR2(25);
74: CURSOR bal_seg_val_cur IS
75: SELECT DISTINCT bal_seg_column_name
76: FROM fun_bal_headers_gt headers
77: WHERE headers.status = 'OK';
78: BEGIN
79: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
80: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.update_inter_seg_val.begin', 'begin');

Line 455: SELECT * FROM fun_bal_headers_gt;

451: ins_results_t(results_tab, results_count);
452: ins_errors_t(errors_tab, errors_count);
453: /*
454: INSERT INTO fun_bal_headers_t
455: SELECT * FROM fun_bal_headers_gt;
456: INSERT INTO fun_bal_lines_t
457: SELECT * FROM fun_bal_lines_gt;
458: INSERT INTO fun_bal_results_t
459: SELECT * FROM fun_bal_results_gt;

Line 535: UPDATE fun_bal_headers_gt headers

531: -- code combination already exists in gl_code_combinations table, we would also need to
532: -- retrieve the correct segment_name for intercompany segment.
533: -- update balancing segment column, chart of accounts
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);

Line 541: UPDATE fun_bal_headers_gt headers

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,
543: 'GL_BALANCING'),
544: intercompany_column_number = get_segment_index ( headers.chart_of_accounts_id,
545: 'GL_INTERCOMPANY');

Line 547: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_HEADERS_GT');

543: 'GL_BALANCING'),
544: intercompany_column_number = get_segment_index ( headers.chart_of_accounts_id,
545: 'GL_INTERCOMPANY');
546:
547: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_HEADERS_GT');
548: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_LINES_GT');
549:
550: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
551: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_init.end', 'end');

Line 565: SELECT * FROM fun_bal_headers_gt;

561: l_lines_tab lines_tab_type;
562: l_headers_count NUMBER;
563: l_lines_count NUMBER;
564: CURSOR l_headers_cursor IS
565: SELECT * FROM fun_bal_headers_gt;
566: CURSOR l_lines_cursor IS
567: SELECT * FROM fun_bal_lines_gt;
568: BEGIN
569: OPEN l_headers_cursor;

Line 595: SELECT * FROM fun_bal_headers_gt;

591: l_lines_count NUMBER;
592: l_results_count NUMBER;
593: l_errors_count NUMBER;
594: CURSOR l_headers_cursor IS
595: SELECT * FROM fun_bal_headers_gt;
596: CURSOR l_lines_cursor IS
597: SELECT * FROM fun_bal_lines_gt;
598: CURSOR l_results_cursor IS
599: SELECT * FROM fun_bal_results_gt;

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 718: UPDATE fun_bal_headers_gt headers

714: AND TRUNC(main.gl_date) BETWEEN
715: TRUNC(NVL(vals.start_date, main.gl_date)) AND
716: TRUNC(NVL(vals.end_date, main.gl_date)));
717: -- Bug 3310453
718: UPDATE fun_bal_headers_gt headers
719: SET status = 'ERROR',
720: error_code = 'FUN_BSV_INVALID'
721: WHERE EXISTS (SELECT 'Invalid BSV Error'
722: FROM FUN_BAL_ERRORS_GT errors

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 754: UPDATE fun_bal_headers_gt headers

750: TRUNC(NVL(vals.end_date, main.gl_date)))
751: AND main.ledger_id = vals.ledger_id(+);
752:
753:
754: UPDATE fun_bal_headers_gt headers
755: SET (le_id, le_count) =
756: (SELECT MIN(le_bsv_map.le_id), SUM(COUNT(DISTINCT le_bsv_map.le_id))
757: FROM fun_bal_le_bsv_map_gt le_bsv_map
758: WHERE headers.group_id = le_bsv_map.group_id

Line 763: UPDATE fun_bal_headers_gt headers

759: AND le_bsv_map.le_id <> -99
760: GROUP BY le_bsv_map.group_id, le_bsv_map.le_id);
761:
762:
763: UPDATE fun_bal_headers_gt headers
764: SET status = DECODE(le_id, NULL, status, 'ERROR'),
765: error_code = DECODE(le_id, NULL, error_code, 'FUN_INTER_BSV_NOT_ASSIGNED'),
766: unmapped_bsv_le_id = -99
767: WHERE EXISTS (SELECT 'Unmapped BSV exists'

Line 780: UPDATE fun_bal_headers_gt headers

776: -- III) the clearing BSV entered does not belong to the LE or to the ledger
777: -- or one le count and non-mapped count
778: -- IV) le_count IS NULL and unmapped_bsv_le_id IS NULL if not shared configuration
779: -- and BSV validation set to specific
780: UPDATE fun_bal_headers_gt headers
781: SET status = 'ERROR',
782: error_code = 'FUN_INTRA_OVERRIDE_BSV_ERROR'
783: WHERE headers.status = 'OK'
784: AND headers.clearing_bsv IS NOT NULL

Line 805: UPDATE fun_bal_headers_gt hdrs

801: AND vals.ledger_id = headers.ledger_id
802: AND vals.legal_entity_id IS NOT NULL))); -- Bug 3278912
803:
804: -- Bug 3310453
805: UPDATE fun_bal_headers_gt hdrs
806: SET status = 'ERROR',
807: error_code = 'FUN_INTRA_OVERRIDE_BSV_ERROR'
808: WHERE hdrs.status = 'OK'
809: AND hdrs.clearing_bsv IS NOT NULL

Line 824: FROM fun_bal_headers_gt hdrs

820: TRUNC(NVL(vals.end_date, hdrs.gl_date))));
821:
822: INSERT INTO fun_bal_errors_gt(error_code, group_id, clearing_bsv)
823: SELECT 'FUN_INTRA_OVERRIDE_BSV_ERROR', hdrs.group_id, hdrs.clearing_bsv
824: FROM fun_bal_headers_gt hdrs
825: WHERE hdrs.error_code = 'FUN_INTRA_OVERRIDE_BSV_ERROR';
826:
827: INSERT INTO fun_bal_errors_gt(error_code, group_id, bal_seg_val)
828: SELECT 'FUN_INTER_BSV_NOT_ASSIGNED', hdrs.group_id, le_bsv_map.bal_seg_val

Line 829: FROM fun_bal_headers_gt hdrs, fun_bal_le_bsv_map_gt le_bsv_map

825: WHERE hdrs.error_code = 'FUN_INTRA_OVERRIDE_BSV_ERROR';
826:
827: INSERT INTO fun_bal_errors_gt(error_code, group_id, bal_seg_val)
828: SELECT 'FUN_INTER_BSV_NOT_ASSIGNED', hdrs.group_id, le_bsv_map.bal_seg_val
829: FROM fun_bal_headers_gt hdrs, fun_bal_le_bsv_map_gt le_bsv_map
830: WHERE hdrs.group_id = le_bsv_map.group_id
831: AND hdrs.error_code = 'FUN_INTER_BSV_NOT_ASSIGNED'
832: AND le_bsv_map.le_id = -99;
833:

Line 854: FROM fun_bal_headers_gt headers

850:
851:
852: DELETE FROM fun_bal_le_bsv_map_gt le_bsv_map
853: WHERE group_id = (SELECT group_id
854: FROM fun_bal_headers_gt headers
855: WHERE headers.status = 'ERROR'
856: AND le_bsv_map.group_id = headers.group_id);
857:
858: DELETE FROM fun_bal_le_bsv_map_gt le_bsv_map_del

Line 874: UPDATE fun_bal_headers_gt hdrs

870: SUM(DECODE(lines.exchange_rate, NULL, NVL(lines.entered_amt_dr, 0), 0)));
871:
872:
873: -- Determine driving_dr_le_id, intercompany mode
874: UPDATE fun_bal_headers_gt hdrs
875: SET (driving_dr_le_id, intercompany_mode) =
876: (SELECT MIN(le_bsv_map.le_id),
877: SUM(COUNT(DISTINCT(le_bsv_map.le_id)))
878: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines

Line 899: FROM fun_bal_headers_gt hdrs

895: -- as there won't be any more join to these lines.
896: DELETE FROM fun_bal_le_bsv_map_gt le_bsv_map
897: WHERE EXISTS
898: (SELECT 'Intercompany balancing is not required'
899: FROM fun_bal_headers_gt hdrs
900: WHERE le_bsv_map.group_id = hdrs.group_id
901: AND hdrs.status = 'OK'
902: AND hdrs.intercompany_mode IS NULL);
903:

Line 905: UPDATE fun_bal_headers_gt hdrs

901: AND hdrs.status = 'OK'
902: AND hdrs.intercompany_mode IS NULL);
903:
904: -- Determine driving_cr_le_id, intercompany_mode
905: UPDATE fun_bal_headers_gt hdrs
906: SET (driving_cr_le_id, intercompany_mode) =
907: (SELECT MIN(le_bsv_map.le_id),
908: DECODE(SUM(COUNT(DISTINCT(le_bsv_map.le_id))), 1,
909: DECODE(hdrs.intercompany_mode, 1, 1, 3),

Line 927: FROM fun_bal_headers_gt headers

923: WHERE status = 'OK';
924:
925: DELETE FROM fun_bal_le_bsv_map_gt le_bsv_map
926: WHERE EXISTS (SELECT 'No Driving DR LE or Driving CR LE'
927: FROM fun_bal_headers_gt headers
928: WHERE headers.group_id = le_bsv_map.group_id
929: AND headers.status = 'OK'
930: AND (headers.driving_dr_le_id IS NULL
931: OR

Line 961: fun_bal_headers_gt hdrs

957: 0, DECODE(SIGN(SUM(NVL(lines.entered_amt_cr, 0)) - SUM(NVL(lines.accounted_amt_dr, 0))),
958: 1, 'C',
959: 'D')) type
960: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
961: fun_bal_headers_gt hdrs
962: WHERE hdrs.group_id = lines.group_id
963: AND lines.group_id = le_bsv_map.group_id
964: AND lines.bal_seg_val = le_bsv_map.bal_seg_val
965: AND hdrs.intercompany_mode IN (1,2,3,4)

Line 1468: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs

1464: DECODE(inter_int.rec_acct, -1, NULL, inter_int.rec_acct), 'R',
1465: get_ccid_concat_disp(DECODE(inter_int.rec_acct, -1, NULL, inter_int.rec_acct), hdrs.chart_of_accounts_id,
1466: NULL, NULL, NULL, NULL),
1467: inter_int.driving_dr_le_bsv, inter_int.driving_cr_le_bsv
1468: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs
1469: WHERE inter_int.group_id = hdrs.group_id AND
1470: ((inter_int.intercompany_mode = 1 AND
1471: inter_int.type = 'C')
1472: OR

Line 1516: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs

1512: DECODE(inter_int.pay_acct, -1, NULL, inter_int.pay_acct), 'P',
1513: get_ccid_concat_disp(DECODE(inter_int.pay_acct, -1, NULL, inter_int.pay_acct), hdrs.chart_of_accounts_id,
1514: NULL, NULL, NULL, NULL),
1515: inter_int.driving_dr_le_bsv, inter_int.driving_cr_le_bsv
1516: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs
1517: WHERE inter_int.group_id = hdrs.group_id AND
1518: ((inter_int.intercompany_mode = 1 AND
1519: inter_int.type = 'D')
1520: OR

Line 1545: UPDATE fun_bal_headers_gt headers

1541: AND (TRUNC(inter_int.gl_date) BETWEEN TRUNC(NVL(cc.start_date_active, inter_int.gl_date))
1542: AND TRUNC(NVL(cc.end_date_active, inter_int.gl_date))))));
1543:
1544:
1545: UPDATE fun_bal_headers_gt headers
1546: SET status = 'ERROR'
1547: WHERE EXISTS (SELECT 'Errors for Rec and Pay Accts'
1548: FROM FUN_BAL_ERRORS_GT errors
1549: WHERE headers.group_id = errors.group_id

Line 1560: FROM fun_bal_headers_gt headers

1556: AND headers.status = 'OK';
1557:
1558: DELETE FROM fun_bal_inter_int_gt inter_int
1559: WHERE EXISTS (SELECT group_id
1560: FROM fun_bal_headers_gt headers
1561: WHERE headers.status = 'ERROR'
1562: AND inter_int.group_id = headers.group_id);
1563:
1564: --Enhancement 7520196 Start

Line 1572: fun_bal_headers_gt hdrs

1568: Update fun_bal_inter_int_gt bal_inter_int
1569: set Rec_BSV = (select min_bal_seg_val from (
1570: select min(lines.bal_seg_val) min_bal_seg_val, le_bsv_map.le_id le_id, hdrs.group_id group_id
1571: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
1572: fun_bal_headers_gt hdrs
1573: WHERE hdrs.group_id = lines.group_id
1574: AND lines.group_id = le_bsv_map.group_id
1575: AND lines.bal_seg_val = le_bsv_map.bal_seg_val
1576: AND hdrs.intercompany_mode IN (1,2,3)

Line 1596: fun_bal_headers_gt hdrs

1592: Update fun_bal_inter_int_gt bal_inter_int
1593: set Pay_BSV = (select min_bal_seg_val from (
1594: select min(lines.bal_seg_val) min_bal_seg_val, le_bsv_map.le_id le_id, hdrs.group_id group_id
1595: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
1596: fun_bal_headers_gt hdrs
1597: WHERE hdrs.group_id = lines.group_id
1598: AND lines.group_id = le_bsv_map.group_id
1599: AND lines.bal_seg_val = le_bsv_map.bal_seg_val
1600: AND hdrs.intercompany_mode IN (1,2,3)

Line 1637: from fun_bal_headers_gt hdrs

1633: hdrs.BAL_SEG_COLUMN_NUMBER,
1634: hdrs.INTERCOMPANY_COLUMN_NUMBER,
1635: bal_inter_int.GL_DATE
1636: )
1637: from fun_bal_headers_gt hdrs
1638: where bal_inter_int.group_id = hdrs.group_id)
1639: where bal_inter_int.intercompany_mode in (1, 2, 3)
1640: and bal_inter_int.status = 'OK';
1641:

Line 1665: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs

1661: DECODE(inter_int.rec_acct, -1, NULL, inter_int.rec_acct), 'R',
1662: get_ccid_concat_disp(DECODE(inter_int.rec_acct, -1, NULL, inter_int.rec_acct), hdrs.chart_of_accounts_id,
1663: NULL, NULL, NULL, NULL),
1664: inter_int.driving_dr_le_bsv, inter_int.driving_cr_le_bsv
1665: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs
1666: WHERE inter_int.group_id = hdrs.group_id AND
1667: ((inter_int.intercompany_mode = 1 AND
1668: inter_int.type = 'C')
1669: OR

Line 1713: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs

1709: DECODE(inter_int.pay_acct, -1, NULL, inter_int.pay_acct), 'P',
1710: get_ccid_concat_disp(DECODE(inter_int.pay_acct, -1, NULL, inter_int.pay_acct), hdrs.chart_of_accounts_id,
1711: NULL, NULL, NULL, NULL),
1712: inter_int.driving_dr_le_bsv, inter_int.driving_cr_le_bsv
1713: FROM fun_bal_inter_int_gt inter_int, fun_bal_headers_gt hdrs
1714: WHERE inter_int.group_id = hdrs.group_id AND
1715: ((inter_int.intercompany_mode = 1 AND
1716: inter_int.type = 'D')
1717: OR

Line 1742: UPDATE fun_bal_headers_gt headers

1738: AND (TRUNC(inter_int.gl_date) BETWEEN TRUNC(NVL(cc.start_date_active, inter_int.gl_date))
1739: AND TRUNC(NVL(cc.end_date_active, inter_int.gl_date))))));
1740:
1741:
1742: UPDATE fun_bal_headers_gt headers
1743: SET status = 'ERROR'
1744: WHERE EXISTS (SELECT 'Errors for Rec and Pay Accts'
1745: FROM FUN_BAL_ERRORS_GT errors
1746: WHERE headers.group_id = errors.group_id

Line 1757: FROM fun_bal_headers_gt headers

1753: AND headers.status = 'OK';
1754:
1755: DELETE FROM fun_bal_inter_int_gt inter_int
1756: WHERE EXISTS (SELECT group_id
1757: FROM fun_bal_headers_gt headers
1758: WHERE headers.status = 'ERROR'
1759: AND inter_int.group_id = headers.group_id);
1760:
1761: /* Changes for Bug # 8212023 End */

Line 1968: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines

1964: chart_of_accounts_id, bal_seg_column_number,intercompany_column_number)
1965: SELECT DISTINCT hdrs.group_id, hdrs.ledger_id, lines.bal_seg_val, hdrs.gl_date,
1966: hdrs.je_source_name, hdrs.je_category_name, hdrs.clearing_bsv,
1967: hdrs.chart_of_accounts_id, hdrs.bal_seg_column_number, hdrs.intercompany_column_number
1968: FROM fun_bal_headers_gt hdrs, fun_bal_lines_gt lines
1969: WHERE hdrs.group_id = lines.group_id
1970: AND hdrs.status = 'OK';
1971:
1972:

Line 2228: UPDATE fun_bal_headers_gt headers

2224: AND TRUNC(NVL(gl_seg.end_date, le_bsv_map.gl_date)));
2225:
2226: -- Balancing API Changes, End , Feb 2005
2227:
2228: UPDATE fun_bal_headers_gt headers
2229: SET STATUS = 'ERROR'
2230: WHERE EXISTS (SELECT 'Errors for no template or no clearing bsv or clearing bsv invalid'
2231: FROM FUN_BAL_ERRORS_GT errors
2232: WHERE headers.group_id = errors.group_id

Line 2240: FROM fun_bal_headers_gt headers

2236: AND headers.status = 'OK';
2237:
2238: DELETE FROM fun_bal_le_bsv_map_gt le_bsv_map
2239: WHERE EXISTS (SELECT group_id
2240: FROM fun_bal_headers_gt headers
2241: WHERE headers.status = 'ERROR'
2242: AND le_bsv_map.group_id = headers.group_id);
2243:
2244: -- Update ccid for each DB BSV and CR BSV

Line 2494: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines, fun_bal_headers_gt hdrs

2490: 'D')) type,
2491: */
2492: DECODE(lines.accounted_amt_cr, NULL, DECODE(lines.entered_amt_cr, NULL, 'D', 'C'), 'C') type,
2493: le_bsv_map.clearing_bsv
2494: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines, fun_bal_headers_gt hdrs
2495: WHERE hdrs.group_id = lines.group_id
2496: AND lines.group_id = le_bsv_map.group_id
2497: AND lines.bal_seg_val = le_bsv_map.bal_seg_val
2498: AND hdrs.status = 'OK'

Line 2527: fun_bal_headers_gt hdrs

2523: 0, DECODE(SIGN(SUM(NVL(lines.entered_amt_cr, 0)) - SUM(NVL(lines.accounted_amt_dr, 0))),
2524: 1, 'C',
2525: 'D')) type, le_bsv_map.clearing_bsv
2526: FROM fun_bal_le_bsv_map_gt le_bsv_map, fun_bal_lines_gt lines,
2527: fun_bal_headers_gt hdrs
2528: WHERE hdrs.group_id = lines.group_id
2529: AND lines.group_id = le_bsv_map.group_id
2530: AND lines.bal_seg_val = le_bsv_map.bal_seg_val
2531: AND hdrs.status = 'OK'

Line 2763: FROM fun_bal_headers_gt headers, fun_bal_results_gt results, gl_code_combinations cc

2759: results.acct_type, get_ccid_concat_disp(results.ccid, headers.chart_of_accounts_id,
2760: DECODE(results.acct_type, 'C', results.cr_bsv, results.dr_bsv),
2761: DECODE(results.acct_type, 'C', results.dr_bsv, results.cr_bsv),
2762: headers.bal_seg_column_number, headers.intercompany_column_number)
2763: FROM fun_bal_headers_gt headers, fun_bal_results_gt results, gl_code_combinations cc
2764: WHERE headers.group_id = results.group_id
2765: AND headers.status = 'OK'
2766: AND results.ccid = cc.code_combination_id(+)
2767: AND (results.ccid < 0

Line 2780: UPDATE fun_bal_headers_gt headers

2776: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN
2777: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_bal_pkg.do_intra_bal.get_ccid_concat_disp.end', 'end');
2778: END IF;
2779:
2780: UPDATE fun_bal_headers_gt headers
2781: SET STATUS = 'ERROR'
2782: WHERE EXISTS (SELECT 'Invalid CCID error'
2783: FROM FUN_BAL_ERRORS_GT errors
2784: WHERE headers.group_id = errors.group_id

Line 2792: FROM fun_bal_headers_gt headers

2788:
2789:
2790: DELETE FROM fun_bal_results_gt results
2791: WHERE EXISTS (SELECT group_id
2792: FROM fun_bal_headers_gt headers
2793: WHERE headers.status = 'ERROR'
2794: AND results.group_id = headers.group_id);
2795:
2796: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level) THEN