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.PSA_FUNDS_CHECKER_PKG dependencies on GL_CODE_COMBINATIONS

Line 288: /* GL_CODE_COMBINATIONS */

284: /* GL_JE_BATCHES */
285: /* GL_JE_HEADERS */
286: /* GL_JE_LINES */
287: /* GL_SETS_OF_BOOKS */
288: /* GL_CODE_COMBINATIONS */
289: /* GL_ACCOUNT_HIERARCHIES */
290: /* */
291: /* AOL Tables which are being used include : */
292: /* */

Line 1728: segment1 gl_code_combinations.segment1%TYPE;

1724: cur_ussgl INTEGER;
1725: num_ussgl INTEGER;
1726: ignore INTEGER;
1727:
1728: segment1 gl_code_combinations.segment1%TYPE;
1729: segment2 gl_code_combinations.segment2%TYPE;
1730: segment3 gl_code_combinations.segment3%TYPE;
1731: segment4 gl_code_combinations.segment4%TYPE;
1732: segment5 gl_code_combinations.segment5%TYPE;

Line 1729: segment2 gl_code_combinations.segment2%TYPE;

1725: num_ussgl INTEGER;
1726: ignore INTEGER;
1727:
1728: segment1 gl_code_combinations.segment1%TYPE;
1729: segment2 gl_code_combinations.segment2%TYPE;
1730: segment3 gl_code_combinations.segment3%TYPE;
1731: segment4 gl_code_combinations.segment4%TYPE;
1732: segment5 gl_code_combinations.segment5%TYPE;
1733: segment6 gl_code_combinations.segment6%TYPE;

Line 1730: segment3 gl_code_combinations.segment3%TYPE;

1726: ignore INTEGER;
1727:
1728: segment1 gl_code_combinations.segment1%TYPE;
1729: segment2 gl_code_combinations.segment2%TYPE;
1730: segment3 gl_code_combinations.segment3%TYPE;
1731: segment4 gl_code_combinations.segment4%TYPE;
1732: segment5 gl_code_combinations.segment5%TYPE;
1733: segment6 gl_code_combinations.segment6%TYPE;
1734: segment7 gl_code_combinations.segment7%TYPE;

Line 1731: segment4 gl_code_combinations.segment4%TYPE;

1727:
1728: segment1 gl_code_combinations.segment1%TYPE;
1729: segment2 gl_code_combinations.segment2%TYPE;
1730: segment3 gl_code_combinations.segment3%TYPE;
1731: segment4 gl_code_combinations.segment4%TYPE;
1732: segment5 gl_code_combinations.segment5%TYPE;
1733: segment6 gl_code_combinations.segment6%TYPE;
1734: segment7 gl_code_combinations.segment7%TYPE;
1735: segment8 gl_code_combinations.segment8%TYPE;

Line 1732: segment5 gl_code_combinations.segment5%TYPE;

1728: segment1 gl_code_combinations.segment1%TYPE;
1729: segment2 gl_code_combinations.segment2%TYPE;
1730: segment3 gl_code_combinations.segment3%TYPE;
1731: segment4 gl_code_combinations.segment4%TYPE;
1732: segment5 gl_code_combinations.segment5%TYPE;
1733: segment6 gl_code_combinations.segment6%TYPE;
1734: segment7 gl_code_combinations.segment7%TYPE;
1735: segment8 gl_code_combinations.segment8%TYPE;
1736: segment9 gl_code_combinations.segment9%TYPE;

Line 1733: segment6 gl_code_combinations.segment6%TYPE;

1729: segment2 gl_code_combinations.segment2%TYPE;
1730: segment3 gl_code_combinations.segment3%TYPE;
1731: segment4 gl_code_combinations.segment4%TYPE;
1732: segment5 gl_code_combinations.segment5%TYPE;
1733: segment6 gl_code_combinations.segment6%TYPE;
1734: segment7 gl_code_combinations.segment7%TYPE;
1735: segment8 gl_code_combinations.segment8%TYPE;
1736: segment9 gl_code_combinations.segment9%TYPE;
1737: segment10 gl_code_combinations.segment10%TYPE;

Line 1734: segment7 gl_code_combinations.segment7%TYPE;

1730: segment3 gl_code_combinations.segment3%TYPE;
1731: segment4 gl_code_combinations.segment4%TYPE;
1732: segment5 gl_code_combinations.segment5%TYPE;
1733: segment6 gl_code_combinations.segment6%TYPE;
1734: segment7 gl_code_combinations.segment7%TYPE;
1735: segment8 gl_code_combinations.segment8%TYPE;
1736: segment9 gl_code_combinations.segment9%TYPE;
1737: segment10 gl_code_combinations.segment10%TYPE;
1738: segment11 gl_code_combinations.segment11%TYPE;

Line 1735: segment8 gl_code_combinations.segment8%TYPE;

1731: segment4 gl_code_combinations.segment4%TYPE;
1732: segment5 gl_code_combinations.segment5%TYPE;
1733: segment6 gl_code_combinations.segment6%TYPE;
1734: segment7 gl_code_combinations.segment7%TYPE;
1735: segment8 gl_code_combinations.segment8%TYPE;
1736: segment9 gl_code_combinations.segment9%TYPE;
1737: segment10 gl_code_combinations.segment10%TYPE;
1738: segment11 gl_code_combinations.segment11%TYPE;
1739: segment12 gl_code_combinations.segment12%TYPE;

Line 1736: segment9 gl_code_combinations.segment9%TYPE;

1732: segment5 gl_code_combinations.segment5%TYPE;
1733: segment6 gl_code_combinations.segment6%TYPE;
1734: segment7 gl_code_combinations.segment7%TYPE;
1735: segment8 gl_code_combinations.segment8%TYPE;
1736: segment9 gl_code_combinations.segment9%TYPE;
1737: segment10 gl_code_combinations.segment10%TYPE;
1738: segment11 gl_code_combinations.segment11%TYPE;
1739: segment12 gl_code_combinations.segment12%TYPE;
1740: segment13 gl_code_combinations.segment13%TYPE;

Line 1737: segment10 gl_code_combinations.segment10%TYPE;

1733: segment6 gl_code_combinations.segment6%TYPE;
1734: segment7 gl_code_combinations.segment7%TYPE;
1735: segment8 gl_code_combinations.segment8%TYPE;
1736: segment9 gl_code_combinations.segment9%TYPE;
1737: segment10 gl_code_combinations.segment10%TYPE;
1738: segment11 gl_code_combinations.segment11%TYPE;
1739: segment12 gl_code_combinations.segment12%TYPE;
1740: segment13 gl_code_combinations.segment13%TYPE;
1741: segment14 gl_code_combinations.segment14%TYPE;

Line 1738: segment11 gl_code_combinations.segment11%TYPE;

1734: segment7 gl_code_combinations.segment7%TYPE;
1735: segment8 gl_code_combinations.segment8%TYPE;
1736: segment9 gl_code_combinations.segment9%TYPE;
1737: segment10 gl_code_combinations.segment10%TYPE;
1738: segment11 gl_code_combinations.segment11%TYPE;
1739: segment12 gl_code_combinations.segment12%TYPE;
1740: segment13 gl_code_combinations.segment13%TYPE;
1741: segment14 gl_code_combinations.segment14%TYPE;
1742: segment15 gl_code_combinations.segment15%TYPE;

Line 1739: segment12 gl_code_combinations.segment12%TYPE;

1735: segment8 gl_code_combinations.segment8%TYPE;
1736: segment9 gl_code_combinations.segment9%TYPE;
1737: segment10 gl_code_combinations.segment10%TYPE;
1738: segment11 gl_code_combinations.segment11%TYPE;
1739: segment12 gl_code_combinations.segment12%TYPE;
1740: segment13 gl_code_combinations.segment13%TYPE;
1741: segment14 gl_code_combinations.segment14%TYPE;
1742: segment15 gl_code_combinations.segment15%TYPE;
1743: segment16 gl_code_combinations.segment16%TYPE;

Line 1740: segment13 gl_code_combinations.segment13%TYPE;

1736: segment9 gl_code_combinations.segment9%TYPE;
1737: segment10 gl_code_combinations.segment10%TYPE;
1738: segment11 gl_code_combinations.segment11%TYPE;
1739: segment12 gl_code_combinations.segment12%TYPE;
1740: segment13 gl_code_combinations.segment13%TYPE;
1741: segment14 gl_code_combinations.segment14%TYPE;
1742: segment15 gl_code_combinations.segment15%TYPE;
1743: segment16 gl_code_combinations.segment16%TYPE;
1744: segment17 gl_code_combinations.segment17%TYPE;

Line 1741: segment14 gl_code_combinations.segment14%TYPE;

1737: segment10 gl_code_combinations.segment10%TYPE;
1738: segment11 gl_code_combinations.segment11%TYPE;
1739: segment12 gl_code_combinations.segment12%TYPE;
1740: segment13 gl_code_combinations.segment13%TYPE;
1741: segment14 gl_code_combinations.segment14%TYPE;
1742: segment15 gl_code_combinations.segment15%TYPE;
1743: segment16 gl_code_combinations.segment16%TYPE;
1744: segment17 gl_code_combinations.segment17%TYPE;
1745: segment18 gl_code_combinations.segment18%TYPE;

Line 1742: segment15 gl_code_combinations.segment15%TYPE;

1738: segment11 gl_code_combinations.segment11%TYPE;
1739: segment12 gl_code_combinations.segment12%TYPE;
1740: segment13 gl_code_combinations.segment13%TYPE;
1741: segment14 gl_code_combinations.segment14%TYPE;
1742: segment15 gl_code_combinations.segment15%TYPE;
1743: segment16 gl_code_combinations.segment16%TYPE;
1744: segment17 gl_code_combinations.segment17%TYPE;
1745: segment18 gl_code_combinations.segment18%TYPE;
1746: segment19 gl_code_combinations.segment19%TYPE;

Line 1743: segment16 gl_code_combinations.segment16%TYPE;

1739: segment12 gl_code_combinations.segment12%TYPE;
1740: segment13 gl_code_combinations.segment13%TYPE;
1741: segment14 gl_code_combinations.segment14%TYPE;
1742: segment15 gl_code_combinations.segment15%TYPE;
1743: segment16 gl_code_combinations.segment16%TYPE;
1744: segment17 gl_code_combinations.segment17%TYPE;
1745: segment18 gl_code_combinations.segment18%TYPE;
1746: segment19 gl_code_combinations.segment19%TYPE;
1747: segment20 gl_code_combinations.segment20%TYPE;

Line 1744: segment17 gl_code_combinations.segment17%TYPE;

1740: segment13 gl_code_combinations.segment13%TYPE;
1741: segment14 gl_code_combinations.segment14%TYPE;
1742: segment15 gl_code_combinations.segment15%TYPE;
1743: segment16 gl_code_combinations.segment16%TYPE;
1744: segment17 gl_code_combinations.segment17%TYPE;
1745: segment18 gl_code_combinations.segment18%TYPE;
1746: segment19 gl_code_combinations.segment19%TYPE;
1747: segment20 gl_code_combinations.segment20%TYPE;
1748: segment21 gl_code_combinations.segment21%TYPE;

Line 1745: segment18 gl_code_combinations.segment18%TYPE;

1741: segment14 gl_code_combinations.segment14%TYPE;
1742: segment15 gl_code_combinations.segment15%TYPE;
1743: segment16 gl_code_combinations.segment16%TYPE;
1744: segment17 gl_code_combinations.segment17%TYPE;
1745: segment18 gl_code_combinations.segment18%TYPE;
1746: segment19 gl_code_combinations.segment19%TYPE;
1747: segment20 gl_code_combinations.segment20%TYPE;
1748: segment21 gl_code_combinations.segment21%TYPE;
1749: segment22 gl_code_combinations.segment22%TYPE;

Line 1746: segment19 gl_code_combinations.segment19%TYPE;

1742: segment15 gl_code_combinations.segment15%TYPE;
1743: segment16 gl_code_combinations.segment16%TYPE;
1744: segment17 gl_code_combinations.segment17%TYPE;
1745: segment18 gl_code_combinations.segment18%TYPE;
1746: segment19 gl_code_combinations.segment19%TYPE;
1747: segment20 gl_code_combinations.segment20%TYPE;
1748: segment21 gl_code_combinations.segment21%TYPE;
1749: segment22 gl_code_combinations.segment22%TYPE;
1750: segment23 gl_code_combinations.segment23%TYPE;

Line 1747: segment20 gl_code_combinations.segment20%TYPE;

1743: segment16 gl_code_combinations.segment16%TYPE;
1744: segment17 gl_code_combinations.segment17%TYPE;
1745: segment18 gl_code_combinations.segment18%TYPE;
1746: segment19 gl_code_combinations.segment19%TYPE;
1747: segment20 gl_code_combinations.segment20%TYPE;
1748: segment21 gl_code_combinations.segment21%TYPE;
1749: segment22 gl_code_combinations.segment22%TYPE;
1750: segment23 gl_code_combinations.segment23%TYPE;
1751: segment24 gl_code_combinations.segment24%TYPE;

Line 1748: segment21 gl_code_combinations.segment21%TYPE;

1744: segment17 gl_code_combinations.segment17%TYPE;
1745: segment18 gl_code_combinations.segment18%TYPE;
1746: segment19 gl_code_combinations.segment19%TYPE;
1747: segment20 gl_code_combinations.segment20%TYPE;
1748: segment21 gl_code_combinations.segment21%TYPE;
1749: segment22 gl_code_combinations.segment22%TYPE;
1750: segment23 gl_code_combinations.segment23%TYPE;
1751: segment24 gl_code_combinations.segment24%TYPE;
1752: segment25 gl_code_combinations.segment25%TYPE;

Line 1749: segment22 gl_code_combinations.segment22%TYPE;

1745: segment18 gl_code_combinations.segment18%TYPE;
1746: segment19 gl_code_combinations.segment19%TYPE;
1747: segment20 gl_code_combinations.segment20%TYPE;
1748: segment21 gl_code_combinations.segment21%TYPE;
1749: segment22 gl_code_combinations.segment22%TYPE;
1750: segment23 gl_code_combinations.segment23%TYPE;
1751: segment24 gl_code_combinations.segment24%TYPE;
1752: segment25 gl_code_combinations.segment25%TYPE;
1753: segment26 gl_code_combinations.segment26%TYPE;

Line 1750: segment23 gl_code_combinations.segment23%TYPE;

1746: segment19 gl_code_combinations.segment19%TYPE;
1747: segment20 gl_code_combinations.segment20%TYPE;
1748: segment21 gl_code_combinations.segment21%TYPE;
1749: segment22 gl_code_combinations.segment22%TYPE;
1750: segment23 gl_code_combinations.segment23%TYPE;
1751: segment24 gl_code_combinations.segment24%TYPE;
1752: segment25 gl_code_combinations.segment25%TYPE;
1753: segment26 gl_code_combinations.segment26%TYPE;
1754: segment27 gl_code_combinations.segment27%TYPE;

Line 1751: segment24 gl_code_combinations.segment24%TYPE;

1747: segment20 gl_code_combinations.segment20%TYPE;
1748: segment21 gl_code_combinations.segment21%TYPE;
1749: segment22 gl_code_combinations.segment22%TYPE;
1750: segment23 gl_code_combinations.segment23%TYPE;
1751: segment24 gl_code_combinations.segment24%TYPE;
1752: segment25 gl_code_combinations.segment25%TYPE;
1753: segment26 gl_code_combinations.segment26%TYPE;
1754: segment27 gl_code_combinations.segment27%TYPE;
1755: segment28 gl_code_combinations.segment28%TYPE;

Line 1752: segment25 gl_code_combinations.segment25%TYPE;

1748: segment21 gl_code_combinations.segment21%TYPE;
1749: segment22 gl_code_combinations.segment22%TYPE;
1750: segment23 gl_code_combinations.segment23%TYPE;
1751: segment24 gl_code_combinations.segment24%TYPE;
1752: segment25 gl_code_combinations.segment25%TYPE;
1753: segment26 gl_code_combinations.segment26%TYPE;
1754: segment27 gl_code_combinations.segment27%TYPE;
1755: segment28 gl_code_combinations.segment28%TYPE;
1756: segment29 gl_code_combinations.segment29%TYPE;

Line 1753: segment26 gl_code_combinations.segment26%TYPE;

1749: segment22 gl_code_combinations.segment22%TYPE;
1750: segment23 gl_code_combinations.segment23%TYPE;
1751: segment24 gl_code_combinations.segment24%TYPE;
1752: segment25 gl_code_combinations.segment25%TYPE;
1753: segment26 gl_code_combinations.segment26%TYPE;
1754: segment27 gl_code_combinations.segment27%TYPE;
1755: segment28 gl_code_combinations.segment28%TYPE;
1756: segment29 gl_code_combinations.segment29%TYPE;
1757: segment30 gl_code_combinations.segment30%TYPE;

Line 1754: segment27 gl_code_combinations.segment27%TYPE;

1750: segment23 gl_code_combinations.segment23%TYPE;
1751: segment24 gl_code_combinations.segment24%TYPE;
1752: segment25 gl_code_combinations.segment25%TYPE;
1753: segment26 gl_code_combinations.segment26%TYPE;
1754: segment27 gl_code_combinations.segment27%TYPE;
1755: segment28 gl_code_combinations.segment28%TYPE;
1756: segment29 gl_code_combinations.segment29%TYPE;
1757: segment30 gl_code_combinations.segment30%TYPE;
1758:

Line 1755: segment28 gl_code_combinations.segment28%TYPE;

1751: segment24 gl_code_combinations.segment24%TYPE;
1752: segment25 gl_code_combinations.segment25%TYPE;
1753: segment26 gl_code_combinations.segment26%TYPE;
1754: segment27 gl_code_combinations.segment27%TYPE;
1755: segment28 gl_code_combinations.segment28%TYPE;
1756: segment29 gl_code_combinations.segment29%TYPE;
1757: segment30 gl_code_combinations.segment30%TYPE;
1758:
1759: cursor ussgl is

Line 1756: segment29 gl_code_combinations.segment29%TYPE;

1752: segment25 gl_code_combinations.segment25%TYPE;
1753: segment26 gl_code_combinations.segment26%TYPE;
1754: segment27 gl_code_combinations.segment27%TYPE;
1755: segment28 gl_code_combinations.segment28%TYPE;
1756: segment29 gl_code_combinations.segment29%TYPE;
1757: segment30 gl_code_combinations.segment30%TYPE;
1758:
1759: cursor ussgl is
1760: select 'USSGL Rows need to be created'

Line 1757: segment30 gl_code_combinations.segment30%TYPE;

1753: segment26 gl_code_combinations.segment26%TYPE;
1754: segment27 gl_code_combinations.segment27%TYPE;
1755: segment28 gl_code_combinations.segment28%TYPE;
1756: segment29 gl_code_combinations.segment29%TYPE;
1757: segment30 gl_code_combinations.segment30%TYPE;
1758:
1759: cursor ussgl is
1760: select 'USSGL Rows need to be created'
1761: from dual

Line 2150: 'gl_code_combinations ccg, ' ||

2146: sql_ussgl := sql_ussgl ||
2147: 'from gl_lookups lu, ' ||
2148: 'gl_ussgl_transaction_codes uc, ' ||
2149: 'gl_ussgl_account_pairs guap, ' ||
2150: 'gl_code_combinations ccg, ' ||
2151: 'gl_code_combinations cco, ' ||
2152: 'gl_bc_packets bp, ' ||
2153: 'psa_event_types pet ' ||
2154: 'where lu.lookup_type = ''DR_CR'' ' ||

Line 2151: 'gl_code_combinations cco, ' ||

2147: 'from gl_lookups lu, ' ||
2148: 'gl_ussgl_transaction_codes uc, ' ||
2149: 'gl_ussgl_account_pairs guap, ' ||
2150: 'gl_code_combinations ccg, ' ||
2151: 'gl_code_combinations cco, ' ||
2152: 'gl_bc_packets bp, ' ||
2153: 'psa_event_types pet ' ||
2154: 'where lu.lookup_type = ''DR_CR'' ' ||
2155: 'and pet.je_source (+) = bp.je_source_name ' ||

Line 2176: 'from gl_code_combinations ccg1 ' ||

2172: 'and ccg.code_combination_id = ' ||
2173: '(' ||
2174: 'select nvl(min(ccg1.code_combination_id), ' ||
2175: 'cco.code_combination_id) ' ||
2176: 'from gl_code_combinations ccg1 ' ||
2177: 'where ccg1.chart_of_accounts_id = ' ||
2178: g_coa_id;
2179: else
2180:

Line 2186: 'gl_code_combinations ccg, ' ||

2182:
2183: 'from gl_lookups lu, ' ||
2184: 'gl_ussgl_transaction_codes uc, ' ||
2185: 'gl_ussgl_account_pairs guap, ' ||
2186: 'gl_code_combinations ccg, ' ||
2187: 'gl_code_combinations cco, ' ||
2188: 'gl_bc_packets bp ' ||
2189: 'where lu.lookup_type = ''DR_CR'' ' ||
2190: 'and uc.chart_of_accounts_id = ' ||

Line 2187: 'gl_code_combinations cco, ' ||

2183: 'from gl_lookups lu, ' ||
2184: 'gl_ussgl_transaction_codes uc, ' ||
2185: 'gl_ussgl_account_pairs guap, ' ||
2186: 'gl_code_combinations ccg, ' ||
2187: 'gl_code_combinations cco, ' ||
2188: 'gl_bc_packets bp ' ||
2189: 'where lu.lookup_type = ''DR_CR'' ' ||
2190: 'and uc.chart_of_accounts_id = ' ||
2191: 'guap.chart_of_accounts_id ' ||

Line 2204: 'from gl_code_combinations ccg1 ' ||

2200: 'and ccg.code_combination_id = ' ||
2201: '(' ||
2202: 'select nvl(min(ccg1.code_combination_id), ' ||
2203: 'cco.code_combination_id) ' ||
2204: 'from gl_code_combinations ccg1 ' ||
2205: 'where ccg1.chart_of_accounts_id = ' ||
2206: g_coa_id;
2207: end if;
2208:

Line 2269: 'from gl_code_combinations cc, ' ||

2265: end loop;
2266:
2267: sql_ussgl := sql_ussgl ||
2268: 'bp.code_combination_id ' ||
2269: 'from gl_code_combinations cc, ' ||
2270: 'gl_bc_packets bp ' ||
2271: 'where cc.code_combination_id = -1 * bp.code_combination_id ' ||
2272: 'and bp.packet_id = ' || g_packet_id || ' ' ||
2273: 'and bp.code_combination_id < 0 ' ||

Line 3003: gl_code_combinations cc,

2999: from gl_ussgl_transaction_codes uc,
3000: gl_budget_versions bv,
3001: gl_budget_period_ranges br,
3002: gl_period_statuses ps,
3003: gl_code_combinations cc,
3004: psa_option_details_gt od,
3005: gl_bc_packets pk
3006: where uc.chart_of_accounts_id (+) = g_coa_id
3007: and uc.ussgl_transaction_code (+) =

Line 7773: l_je_bud_ccid gl_code_combinations.code_combination_id%TYPE;

7769: l_je_bud_dr gl_bc_packets.entered_dr%TYPE;
7770: l_je_bud_cr gl_bc_packets.entered_cr%TYPE;
7771: l_je_bud_result_code gl_bc_packets.result_code%TYPE;
7772: l_je_bud_desc gl_lookups.description%TYPE;
7773: l_je_bud_ccid gl_code_combinations.code_combination_id%TYPE;
7774: l_ussgl_parent_id gl_bc_packets.ussgl_parent_id%TYPE;
7775: l_je_bud_seg_stmt varchar2(4000);
7776: l_je_bud_sum_flex varchar2(4000);
7777:

Line 8341: 'FROM gl_je_lines l, gl_je_headers h, gl_code_combinations c, '||

8337:
8338: l_je_stmt := l_je_stmt||', SUBSTRB(h.name,1,20), h.je_header_id, l.je_line_num, l.entered_dr, '||
8339: 'l.entered_cr, lk.description, p.result_code, l.code_combination_id, '||
8340: 'p.rowid '||
8341: 'FROM gl_je_lines l, gl_je_headers h, gl_code_combinations c, '||
8342: 'gl_lookups lk, gl_bc_packets p '||
8343: 'WHERE p.je_batch_id = '||l_failed_bc_pkts(x).je_batch_id||
8344: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8345: ' and p.ledger_id = '||l_ledger_id||

Line 8445: l_je_seg_stmt := l_je_seg_stmt||' FROM gl_code_combinations c, gl_account_hierarchies h, '||

8441: END IF;
8442:
8443: END LOOP; --End of segments loop
8444:
8445: l_je_seg_stmt := l_je_seg_stmt||' FROM gl_code_combinations c, gl_account_hierarchies h, '||
8446: ' gl_bc_packets p where h.detail_code_combination_id = '||
8447: l_ccid||' and p.code_combination_id = h.summary_code_combination_id '||
8448: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8449: ' and c.code_combination_id = p.code_combination_id';

Line 8520: ' c.code_combination_id FROM gl_code_combinations c, gl_bc_packets p, '||

8516: -- ========================= FND LOG =============================
8517: END;
8518:
8519: l_je_bud_stmt := l_je_bud_stmt||' , p.entered_dr, p.entered_cr, p.result_code, l.description, '||
8520: ' c.code_combination_id FROM gl_code_combinations c, gl_bc_packets p, '||
8521: ' gl_lookups l WHERE p.ussgl_link_to_parent_id = '||l_ussgl_parent_id||
8522: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8523: ' and c.code_combination_id = p.code_combination_id'||
8524: ' and p.result_code between ''F00'' AND ''F30'' and '||

Line 8582: l_je_bud_seg_stmt := l_je_bud_seg_stmt||' FROM gl_code_combinations c, gl_account_hierarchies h, '||

8578: END IF;
8579:
8580: END LOOP; --End of segments loop
8581:
8582: l_je_bud_seg_stmt := l_je_bud_seg_stmt||' FROM gl_code_combinations c, gl_account_hierarchies h, '||
8583: ' gl_bc_packets p where h.detail_code_combination_id = '||
8584: l_je_bud_ccid||' and p.code_combination_id = h.summary_code_combination_id '||
8585: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8586: ' and c.code_combination_id = p.code_combination_id';

Line 9100: FROM gl_code_combinations

9096: AND ao.packet_id = bp2.packet_id)
9097: WHERE bp2.ledger_id = p_ledger_id
9098: AND bp2.template_id = p_curr_temp_id
9099: AND bp2.code_combination_id IN (SELECT code_combination_id
9100: FROM gl_code_combinations
9101: WHERE template_id = p_curr_temp_id);
9102:
9103: -- =========================== FND LOG ===========================
9104: psa_utils.debug_other_string(g_state_level,l_full_path, ' Update GL_BC_PACKETS -> ' || SQL%ROWCOUNT);