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 299: /* GL_CODE_COMBINATIONS */

295: /* GL_JE_BATCHES */
296: /* GL_JE_HEADERS */
297: /* GL_JE_LINES */
298: /* GL_SETS_OF_BOOKS */
299: /* GL_CODE_COMBINATIONS */
300: /* GL_ACCOUNT_HIERARCHIES */
301: /* */
302: /* AOL Tables which are being used include : */
303: /* */

Line 1739: segment1 gl_code_combinations.segment1%TYPE;

1735: cur_ussgl INTEGER;
1736: num_ussgl INTEGER;
1737: ignore INTEGER;
1738:
1739: segment1 gl_code_combinations.segment1%TYPE;
1740: segment2 gl_code_combinations.segment2%TYPE;
1741: segment3 gl_code_combinations.segment3%TYPE;
1742: segment4 gl_code_combinations.segment4%TYPE;
1743: segment5 gl_code_combinations.segment5%TYPE;

Line 1740: segment2 gl_code_combinations.segment2%TYPE;

1736: num_ussgl INTEGER;
1737: ignore INTEGER;
1738:
1739: segment1 gl_code_combinations.segment1%TYPE;
1740: segment2 gl_code_combinations.segment2%TYPE;
1741: segment3 gl_code_combinations.segment3%TYPE;
1742: segment4 gl_code_combinations.segment4%TYPE;
1743: segment5 gl_code_combinations.segment5%TYPE;
1744: segment6 gl_code_combinations.segment6%TYPE;

Line 1741: segment3 gl_code_combinations.segment3%TYPE;

1737: ignore INTEGER;
1738:
1739: segment1 gl_code_combinations.segment1%TYPE;
1740: segment2 gl_code_combinations.segment2%TYPE;
1741: segment3 gl_code_combinations.segment3%TYPE;
1742: segment4 gl_code_combinations.segment4%TYPE;
1743: segment5 gl_code_combinations.segment5%TYPE;
1744: segment6 gl_code_combinations.segment6%TYPE;
1745: segment7 gl_code_combinations.segment7%TYPE;

Line 1742: segment4 gl_code_combinations.segment4%TYPE;

1738:
1739: segment1 gl_code_combinations.segment1%TYPE;
1740: segment2 gl_code_combinations.segment2%TYPE;
1741: segment3 gl_code_combinations.segment3%TYPE;
1742: segment4 gl_code_combinations.segment4%TYPE;
1743: segment5 gl_code_combinations.segment5%TYPE;
1744: segment6 gl_code_combinations.segment6%TYPE;
1745: segment7 gl_code_combinations.segment7%TYPE;
1746: segment8 gl_code_combinations.segment8%TYPE;

Line 1743: segment5 gl_code_combinations.segment5%TYPE;

1739: segment1 gl_code_combinations.segment1%TYPE;
1740: segment2 gl_code_combinations.segment2%TYPE;
1741: segment3 gl_code_combinations.segment3%TYPE;
1742: segment4 gl_code_combinations.segment4%TYPE;
1743: segment5 gl_code_combinations.segment5%TYPE;
1744: segment6 gl_code_combinations.segment6%TYPE;
1745: segment7 gl_code_combinations.segment7%TYPE;
1746: segment8 gl_code_combinations.segment8%TYPE;
1747: segment9 gl_code_combinations.segment9%TYPE;

Line 1744: segment6 gl_code_combinations.segment6%TYPE;

1740: segment2 gl_code_combinations.segment2%TYPE;
1741: segment3 gl_code_combinations.segment3%TYPE;
1742: segment4 gl_code_combinations.segment4%TYPE;
1743: segment5 gl_code_combinations.segment5%TYPE;
1744: segment6 gl_code_combinations.segment6%TYPE;
1745: segment7 gl_code_combinations.segment7%TYPE;
1746: segment8 gl_code_combinations.segment8%TYPE;
1747: segment9 gl_code_combinations.segment9%TYPE;
1748: segment10 gl_code_combinations.segment10%TYPE;

Line 1745: segment7 gl_code_combinations.segment7%TYPE;

1741: segment3 gl_code_combinations.segment3%TYPE;
1742: segment4 gl_code_combinations.segment4%TYPE;
1743: segment5 gl_code_combinations.segment5%TYPE;
1744: segment6 gl_code_combinations.segment6%TYPE;
1745: segment7 gl_code_combinations.segment7%TYPE;
1746: segment8 gl_code_combinations.segment8%TYPE;
1747: segment9 gl_code_combinations.segment9%TYPE;
1748: segment10 gl_code_combinations.segment10%TYPE;
1749: segment11 gl_code_combinations.segment11%TYPE;

Line 1746: segment8 gl_code_combinations.segment8%TYPE;

1742: segment4 gl_code_combinations.segment4%TYPE;
1743: segment5 gl_code_combinations.segment5%TYPE;
1744: segment6 gl_code_combinations.segment6%TYPE;
1745: segment7 gl_code_combinations.segment7%TYPE;
1746: segment8 gl_code_combinations.segment8%TYPE;
1747: segment9 gl_code_combinations.segment9%TYPE;
1748: segment10 gl_code_combinations.segment10%TYPE;
1749: segment11 gl_code_combinations.segment11%TYPE;
1750: segment12 gl_code_combinations.segment12%TYPE;

Line 1747: segment9 gl_code_combinations.segment9%TYPE;

1743: segment5 gl_code_combinations.segment5%TYPE;
1744: segment6 gl_code_combinations.segment6%TYPE;
1745: segment7 gl_code_combinations.segment7%TYPE;
1746: segment8 gl_code_combinations.segment8%TYPE;
1747: segment9 gl_code_combinations.segment9%TYPE;
1748: segment10 gl_code_combinations.segment10%TYPE;
1749: segment11 gl_code_combinations.segment11%TYPE;
1750: segment12 gl_code_combinations.segment12%TYPE;
1751: segment13 gl_code_combinations.segment13%TYPE;

Line 1748: segment10 gl_code_combinations.segment10%TYPE;

1744: segment6 gl_code_combinations.segment6%TYPE;
1745: segment7 gl_code_combinations.segment7%TYPE;
1746: segment8 gl_code_combinations.segment8%TYPE;
1747: segment9 gl_code_combinations.segment9%TYPE;
1748: segment10 gl_code_combinations.segment10%TYPE;
1749: segment11 gl_code_combinations.segment11%TYPE;
1750: segment12 gl_code_combinations.segment12%TYPE;
1751: segment13 gl_code_combinations.segment13%TYPE;
1752: segment14 gl_code_combinations.segment14%TYPE;

Line 1749: segment11 gl_code_combinations.segment11%TYPE;

1745: segment7 gl_code_combinations.segment7%TYPE;
1746: segment8 gl_code_combinations.segment8%TYPE;
1747: segment9 gl_code_combinations.segment9%TYPE;
1748: segment10 gl_code_combinations.segment10%TYPE;
1749: segment11 gl_code_combinations.segment11%TYPE;
1750: segment12 gl_code_combinations.segment12%TYPE;
1751: segment13 gl_code_combinations.segment13%TYPE;
1752: segment14 gl_code_combinations.segment14%TYPE;
1753: segment15 gl_code_combinations.segment15%TYPE;

Line 1750: segment12 gl_code_combinations.segment12%TYPE;

1746: segment8 gl_code_combinations.segment8%TYPE;
1747: segment9 gl_code_combinations.segment9%TYPE;
1748: segment10 gl_code_combinations.segment10%TYPE;
1749: segment11 gl_code_combinations.segment11%TYPE;
1750: segment12 gl_code_combinations.segment12%TYPE;
1751: segment13 gl_code_combinations.segment13%TYPE;
1752: segment14 gl_code_combinations.segment14%TYPE;
1753: segment15 gl_code_combinations.segment15%TYPE;
1754: segment16 gl_code_combinations.segment16%TYPE;

Line 1751: segment13 gl_code_combinations.segment13%TYPE;

1747: segment9 gl_code_combinations.segment9%TYPE;
1748: segment10 gl_code_combinations.segment10%TYPE;
1749: segment11 gl_code_combinations.segment11%TYPE;
1750: segment12 gl_code_combinations.segment12%TYPE;
1751: segment13 gl_code_combinations.segment13%TYPE;
1752: segment14 gl_code_combinations.segment14%TYPE;
1753: segment15 gl_code_combinations.segment15%TYPE;
1754: segment16 gl_code_combinations.segment16%TYPE;
1755: segment17 gl_code_combinations.segment17%TYPE;

Line 1752: segment14 gl_code_combinations.segment14%TYPE;

1748: segment10 gl_code_combinations.segment10%TYPE;
1749: segment11 gl_code_combinations.segment11%TYPE;
1750: segment12 gl_code_combinations.segment12%TYPE;
1751: segment13 gl_code_combinations.segment13%TYPE;
1752: segment14 gl_code_combinations.segment14%TYPE;
1753: segment15 gl_code_combinations.segment15%TYPE;
1754: segment16 gl_code_combinations.segment16%TYPE;
1755: segment17 gl_code_combinations.segment17%TYPE;
1756: segment18 gl_code_combinations.segment18%TYPE;

Line 1753: segment15 gl_code_combinations.segment15%TYPE;

1749: segment11 gl_code_combinations.segment11%TYPE;
1750: segment12 gl_code_combinations.segment12%TYPE;
1751: segment13 gl_code_combinations.segment13%TYPE;
1752: segment14 gl_code_combinations.segment14%TYPE;
1753: segment15 gl_code_combinations.segment15%TYPE;
1754: segment16 gl_code_combinations.segment16%TYPE;
1755: segment17 gl_code_combinations.segment17%TYPE;
1756: segment18 gl_code_combinations.segment18%TYPE;
1757: segment19 gl_code_combinations.segment19%TYPE;

Line 1754: segment16 gl_code_combinations.segment16%TYPE;

1750: segment12 gl_code_combinations.segment12%TYPE;
1751: segment13 gl_code_combinations.segment13%TYPE;
1752: segment14 gl_code_combinations.segment14%TYPE;
1753: segment15 gl_code_combinations.segment15%TYPE;
1754: segment16 gl_code_combinations.segment16%TYPE;
1755: segment17 gl_code_combinations.segment17%TYPE;
1756: segment18 gl_code_combinations.segment18%TYPE;
1757: segment19 gl_code_combinations.segment19%TYPE;
1758: segment20 gl_code_combinations.segment20%TYPE;

Line 1755: segment17 gl_code_combinations.segment17%TYPE;

1751: segment13 gl_code_combinations.segment13%TYPE;
1752: segment14 gl_code_combinations.segment14%TYPE;
1753: segment15 gl_code_combinations.segment15%TYPE;
1754: segment16 gl_code_combinations.segment16%TYPE;
1755: segment17 gl_code_combinations.segment17%TYPE;
1756: segment18 gl_code_combinations.segment18%TYPE;
1757: segment19 gl_code_combinations.segment19%TYPE;
1758: segment20 gl_code_combinations.segment20%TYPE;
1759: segment21 gl_code_combinations.segment21%TYPE;

Line 1756: segment18 gl_code_combinations.segment18%TYPE;

1752: segment14 gl_code_combinations.segment14%TYPE;
1753: segment15 gl_code_combinations.segment15%TYPE;
1754: segment16 gl_code_combinations.segment16%TYPE;
1755: segment17 gl_code_combinations.segment17%TYPE;
1756: segment18 gl_code_combinations.segment18%TYPE;
1757: segment19 gl_code_combinations.segment19%TYPE;
1758: segment20 gl_code_combinations.segment20%TYPE;
1759: segment21 gl_code_combinations.segment21%TYPE;
1760: segment22 gl_code_combinations.segment22%TYPE;

Line 1757: segment19 gl_code_combinations.segment19%TYPE;

1753: segment15 gl_code_combinations.segment15%TYPE;
1754: segment16 gl_code_combinations.segment16%TYPE;
1755: segment17 gl_code_combinations.segment17%TYPE;
1756: segment18 gl_code_combinations.segment18%TYPE;
1757: segment19 gl_code_combinations.segment19%TYPE;
1758: segment20 gl_code_combinations.segment20%TYPE;
1759: segment21 gl_code_combinations.segment21%TYPE;
1760: segment22 gl_code_combinations.segment22%TYPE;
1761: segment23 gl_code_combinations.segment23%TYPE;

Line 1758: segment20 gl_code_combinations.segment20%TYPE;

1754: segment16 gl_code_combinations.segment16%TYPE;
1755: segment17 gl_code_combinations.segment17%TYPE;
1756: segment18 gl_code_combinations.segment18%TYPE;
1757: segment19 gl_code_combinations.segment19%TYPE;
1758: segment20 gl_code_combinations.segment20%TYPE;
1759: segment21 gl_code_combinations.segment21%TYPE;
1760: segment22 gl_code_combinations.segment22%TYPE;
1761: segment23 gl_code_combinations.segment23%TYPE;
1762: segment24 gl_code_combinations.segment24%TYPE;

Line 1759: segment21 gl_code_combinations.segment21%TYPE;

1755: segment17 gl_code_combinations.segment17%TYPE;
1756: segment18 gl_code_combinations.segment18%TYPE;
1757: segment19 gl_code_combinations.segment19%TYPE;
1758: segment20 gl_code_combinations.segment20%TYPE;
1759: segment21 gl_code_combinations.segment21%TYPE;
1760: segment22 gl_code_combinations.segment22%TYPE;
1761: segment23 gl_code_combinations.segment23%TYPE;
1762: segment24 gl_code_combinations.segment24%TYPE;
1763: segment25 gl_code_combinations.segment25%TYPE;

Line 1760: segment22 gl_code_combinations.segment22%TYPE;

1756: segment18 gl_code_combinations.segment18%TYPE;
1757: segment19 gl_code_combinations.segment19%TYPE;
1758: segment20 gl_code_combinations.segment20%TYPE;
1759: segment21 gl_code_combinations.segment21%TYPE;
1760: segment22 gl_code_combinations.segment22%TYPE;
1761: segment23 gl_code_combinations.segment23%TYPE;
1762: segment24 gl_code_combinations.segment24%TYPE;
1763: segment25 gl_code_combinations.segment25%TYPE;
1764: segment26 gl_code_combinations.segment26%TYPE;

Line 1761: segment23 gl_code_combinations.segment23%TYPE;

1757: segment19 gl_code_combinations.segment19%TYPE;
1758: segment20 gl_code_combinations.segment20%TYPE;
1759: segment21 gl_code_combinations.segment21%TYPE;
1760: segment22 gl_code_combinations.segment22%TYPE;
1761: segment23 gl_code_combinations.segment23%TYPE;
1762: segment24 gl_code_combinations.segment24%TYPE;
1763: segment25 gl_code_combinations.segment25%TYPE;
1764: segment26 gl_code_combinations.segment26%TYPE;
1765: segment27 gl_code_combinations.segment27%TYPE;

Line 1762: segment24 gl_code_combinations.segment24%TYPE;

1758: segment20 gl_code_combinations.segment20%TYPE;
1759: segment21 gl_code_combinations.segment21%TYPE;
1760: segment22 gl_code_combinations.segment22%TYPE;
1761: segment23 gl_code_combinations.segment23%TYPE;
1762: segment24 gl_code_combinations.segment24%TYPE;
1763: segment25 gl_code_combinations.segment25%TYPE;
1764: segment26 gl_code_combinations.segment26%TYPE;
1765: segment27 gl_code_combinations.segment27%TYPE;
1766: segment28 gl_code_combinations.segment28%TYPE;

Line 1763: segment25 gl_code_combinations.segment25%TYPE;

1759: segment21 gl_code_combinations.segment21%TYPE;
1760: segment22 gl_code_combinations.segment22%TYPE;
1761: segment23 gl_code_combinations.segment23%TYPE;
1762: segment24 gl_code_combinations.segment24%TYPE;
1763: segment25 gl_code_combinations.segment25%TYPE;
1764: segment26 gl_code_combinations.segment26%TYPE;
1765: segment27 gl_code_combinations.segment27%TYPE;
1766: segment28 gl_code_combinations.segment28%TYPE;
1767: segment29 gl_code_combinations.segment29%TYPE;

Line 1764: segment26 gl_code_combinations.segment26%TYPE;

1760: segment22 gl_code_combinations.segment22%TYPE;
1761: segment23 gl_code_combinations.segment23%TYPE;
1762: segment24 gl_code_combinations.segment24%TYPE;
1763: segment25 gl_code_combinations.segment25%TYPE;
1764: segment26 gl_code_combinations.segment26%TYPE;
1765: segment27 gl_code_combinations.segment27%TYPE;
1766: segment28 gl_code_combinations.segment28%TYPE;
1767: segment29 gl_code_combinations.segment29%TYPE;
1768: segment30 gl_code_combinations.segment30%TYPE;

Line 1765: segment27 gl_code_combinations.segment27%TYPE;

1761: segment23 gl_code_combinations.segment23%TYPE;
1762: segment24 gl_code_combinations.segment24%TYPE;
1763: segment25 gl_code_combinations.segment25%TYPE;
1764: segment26 gl_code_combinations.segment26%TYPE;
1765: segment27 gl_code_combinations.segment27%TYPE;
1766: segment28 gl_code_combinations.segment28%TYPE;
1767: segment29 gl_code_combinations.segment29%TYPE;
1768: segment30 gl_code_combinations.segment30%TYPE;
1769:

Line 1766: segment28 gl_code_combinations.segment28%TYPE;

1762: segment24 gl_code_combinations.segment24%TYPE;
1763: segment25 gl_code_combinations.segment25%TYPE;
1764: segment26 gl_code_combinations.segment26%TYPE;
1765: segment27 gl_code_combinations.segment27%TYPE;
1766: segment28 gl_code_combinations.segment28%TYPE;
1767: segment29 gl_code_combinations.segment29%TYPE;
1768: segment30 gl_code_combinations.segment30%TYPE;
1769:
1770: cursor ussgl is

Line 1767: segment29 gl_code_combinations.segment29%TYPE;

1763: segment25 gl_code_combinations.segment25%TYPE;
1764: segment26 gl_code_combinations.segment26%TYPE;
1765: segment27 gl_code_combinations.segment27%TYPE;
1766: segment28 gl_code_combinations.segment28%TYPE;
1767: segment29 gl_code_combinations.segment29%TYPE;
1768: segment30 gl_code_combinations.segment30%TYPE;
1769:
1770: cursor ussgl is
1771: select 'USSGL Rows need to be created'

Line 1768: segment30 gl_code_combinations.segment30%TYPE;

1764: segment26 gl_code_combinations.segment26%TYPE;
1765: segment27 gl_code_combinations.segment27%TYPE;
1766: segment28 gl_code_combinations.segment28%TYPE;
1767: segment29 gl_code_combinations.segment29%TYPE;
1768: segment30 gl_code_combinations.segment30%TYPE;
1769:
1770: cursor ussgl is
1771: select 'USSGL Rows need to be created'
1772: from dual

Line 2161: 'gl_code_combinations ccg, ' ||

2157: sql_ussgl := sql_ussgl ||
2158: ' from gl_lookups lu, ' ||
2159: 'gl_ussgl_transaction_codes uc, ' ||
2160: 'gl_ussgl_account_pairs guap, ' ||
2161: 'gl_code_combinations ccg, ' ||
2162: 'gl_code_combinations cco, ' ||
2163: 'gl_bc_packets bp, ' ||
2164: 'psa_event_types pet ' ||
2165: 'where lu.lookup_type = ''DR_CR'' ' ||

Line 2162: 'gl_code_combinations cco, ' ||

2158: ' from gl_lookups lu, ' ||
2159: 'gl_ussgl_transaction_codes uc, ' ||
2160: 'gl_ussgl_account_pairs guap, ' ||
2161: 'gl_code_combinations ccg, ' ||
2162: 'gl_code_combinations cco, ' ||
2163: 'gl_bc_packets bp, ' ||
2164: 'psa_event_types pet ' ||
2165: 'where lu.lookup_type = ''DR_CR'' ' ||
2166: 'and pet.je_source (+) = bp.je_source_name ' ||

Line 2187: 'from gl_code_combinations ccg1 ' ||

2183: 'and ccg.code_combination_id = ' ||
2184: '(' ||
2185: 'select nvl(min(ccg1.code_combination_id), ' ||
2186: 'cco.code_combination_id) ' ||
2187: 'from gl_code_combinations ccg1 ' ||
2188: 'where ccg1.chart_of_accounts_id = ' ||
2189: g_coa_id;
2190: else
2191:

Line 2197: 'gl_code_combinations ccg, ' ||

2193:
2194: ' from gl_lookups lu, ' ||
2195: 'gl_ussgl_transaction_codes uc, ' ||
2196: 'gl_ussgl_account_pairs guap, ' ||
2197: 'gl_code_combinations ccg, ' ||
2198: 'gl_code_combinations cco, ' ||
2199: 'gl_bc_packets bp ' ||
2200: 'where lu.lookup_type = ''DR_CR'' ' ||
2201: 'and uc.chart_of_accounts_id = ' ||

Line 2198: 'gl_code_combinations cco, ' ||

2194: ' from gl_lookups lu, ' ||
2195: 'gl_ussgl_transaction_codes uc, ' ||
2196: 'gl_ussgl_account_pairs guap, ' ||
2197: 'gl_code_combinations ccg, ' ||
2198: 'gl_code_combinations cco, ' ||
2199: 'gl_bc_packets bp ' ||
2200: 'where lu.lookup_type = ''DR_CR'' ' ||
2201: 'and uc.chart_of_accounts_id = ' ||
2202: 'guap.chart_of_accounts_id ' ||

Line 2215: 'from gl_code_combinations ccg1 ' ||

2211: 'and ccg.code_combination_id = ' ||
2212: '(' ||
2213: 'select nvl(min(ccg1.code_combination_id), ' ||
2214: 'cco.code_combination_id) ' ||
2215: 'from gl_code_combinations ccg1 ' ||
2216: 'where ccg1.chart_of_accounts_id = ' ||
2217: g_coa_id;
2218: end if;
2219:

Line 2280: 'from gl_code_combinations cc, ' ||

2276: end loop;
2277:
2278: sql_ussgl := sql_ussgl ||
2279: 'bp.code_combination_id ' ||
2280: 'from gl_code_combinations cc, ' ||
2281: 'gl_bc_packets bp ' ||
2282: 'where cc.code_combination_id = -1 * bp.code_combination_id ' ||
2283: 'and bp.packet_id = ' || g_packet_id || ' ' ||
2284: 'and bp.code_combination_id < 0 ' ||

Line 3016: gl_code_combinations cc,

3012: from gl_ussgl_transaction_codes uc,
3013: gl_budget_versions bv,
3014: gl_budget_period_ranges br,
3015: gl_period_statuses ps,
3016: gl_code_combinations cc,
3017: psa_option_details_gt od,
3018: gl_bc_packets pk
3019: where uc.chart_of_accounts_id (+) = g_coa_id
3020: and uc.ussgl_transaction_code (+) =

Line 7959: l_je_bud_ccid gl_code_combinations.code_combination_id%TYPE;

7955: l_je_bud_dr gl_bc_packets.entered_dr%TYPE;
7956: l_je_bud_cr gl_bc_packets.entered_cr%TYPE;
7957: l_je_bud_result_code gl_bc_packets.result_code%TYPE;
7958: l_je_bud_desc gl_lookups.description%TYPE;
7959: l_je_bud_ccid gl_code_combinations.code_combination_id%TYPE;
7960: l_ussgl_parent_id gl_bc_packets.ussgl_parent_id%TYPE;
7961: l_je_bud_seg_stmt varchar2(4000);
7962: l_je_bud_sum_flex varchar2(4000);
7963:

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

8523:
8524: l_je_stmt := l_je_stmt||', SUBSTRB(h.name,1,20), h.je_header_id, l.je_line_num, l.entered_dr, '||
8525: 'l.entered_cr, lk.description, p.result_code, l.code_combination_id, '||
8526: 'p.rowid '||
8527: 'FROM gl_je_lines l, gl_je_headers h, gl_code_combinations c, '||
8528: 'gl_lookups lk, gl_bc_packets p '||
8529: 'WHERE p.je_batch_id = '||l_failed_bc_pkts(x).je_batch_id||
8530: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8531: ' and p.ledger_id = '||l_ledger_id||

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

8627: END IF;
8628:
8629: END LOOP; --End of segments loop
8630:
8631: l_je_seg_stmt := l_je_seg_stmt||' FROM gl_code_combinations c, gl_account_hierarchies h, '||
8632: ' gl_bc_packets p where h.detail_code_combination_id = '||
8633: l_ccid||' and p.code_combination_id = h.summary_code_combination_id '||
8634: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8635: ' and c.code_combination_id = p.code_combination_id';

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

8702: -- ========================= FND LOG =============================
8703: END;
8704:
8705: l_je_bud_stmt := l_je_bud_stmt||' , p.entered_dr, p.entered_cr, p.result_code, l.description, '||
8706: ' c.code_combination_id FROM gl_code_combinations c, gl_bc_packets p, '||
8707: ' gl_lookups l WHERE p.ussgl_link_to_parent_id = '||l_ussgl_parent_id||
8708: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8709: ' and c.code_combination_id = p.code_combination_id'||
8710: ' and p.result_code between ''F00'' AND ''F30'' and '||

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

8764: END IF;
8765:
8766: END LOOP; --End of segments loop
8767:
8768: l_je_bud_seg_stmt := l_je_bud_seg_stmt||' FROM gl_code_combinations c, gl_account_hierarchies h, '||
8769: ' gl_bc_packets p where h.detail_code_combination_id = '||
8770: l_je_bud_ccid||' and p.code_combination_id = h.summary_code_combination_id '||
8771: ' and p.packet_id = '||l_failed_bc_pkts(x).packet_id||
8772: ' and c.code_combination_id = p.code_combination_id';

Line 9286: FROM gl_code_combinations

9282: AND ao.packet_id = bp2.packet_id)
9283: WHERE bp2.ledger_id = p_ledger_id
9284: AND bp2.template_id = p_curr_temp_id
9285: AND bp2.code_combination_id IN (SELECT code_combination_id
9286: FROM gl_code_combinations
9287: WHERE template_id = p_curr_temp_id);
9288:
9289: -- =========================== FND LOG ===========================
9290: psa_utils.debug_other_string(g_state_level,l_full_path, ' Update GL_BC_PACKETS -> ' || SQL%ROWCOUNT);