APPS.FV_SLA_UTL_PROCESSING_PKG dependencies on GL_CODE_COMBINATIONS

Line 188: l_coaid gl_code_combinations.chart_of_accounts_id%TYPE;

184: IS
185: l_debug_info VARCHAR2(240);
186: l_procedure_name VARCHAR2(100):='.get_bank_account_info';
187: l_bank_rec BankRecType;
188: l_coaid gl_code_combinations.chart_of_accounts_id%TYPE;
189: l_accounting_seg_num fnd_id_flex_segments.segment_num%TYPE;
190: l_result BOOLEAN;
191: l_no_of_segments NUMBER;
192: l_segments fnd_flex_ext.SegmentArray;

Line 215: gl_code_combinations g

211: INTO l_bank_rec.cash_bank_account_ccid,
212: l_bank_rec.cash_clearing_ccid,
213: l_coaid
214: FROM ce_gl_accounts_ccid c,
215: gl_code_combinations g
216: WHERE c.bank_acct_use_id = p_bank_acct_use_id
217: AND g.code_combination_id = c.ap_asset_ccid;
218:
219: IF l_bank_rec.cash_clearing_ccid IS NULL THEN

Line 1380: l_ccid Gl_Code_Combinations.code_combination_id%TYPE;

1376: l_ledger_info LedgerRecType;
1377:
1378: --l_anticipated_acct VARCHAR2(30);
1379: l_template_id NUMBER;
1380: l_ccid Gl_Code_Combinations.code_combination_id%TYPE;
1381: l_amount NUMBER;
1382: l_tot_amount NUMBER := 0;
1383:
1384: -- Variable declartions for Dynamic SQL

Line 1466: ' FROM gl_code_Combinations g, ' ||

1462: l_fund_cur_id := DBMS_SQL.OPEN_CURSOR;
1463:
1464: --Build the Select statement for getting the fund values and ccids
1465: l_fund_select := 'SELECT code_combination_id ' ||
1466: ' FROM gl_code_Combinations g, ' ||
1467: ' fv_fund_parameters f'||
1468: ' WHERE g.chart_of_accounts_id = :p_coaid '||
1469: ' AND g.'||l_ledger_info.balancing_seg_name || ' = f.fund_value '||
1470: ' AND f.treasury_symbol_id = :p_treasury_symbol_id '||

Line 1496: -- Fetch the ccid's from Gl_Code_Combinations

1492:
1493: l_fund_ret := DBMS_SQL.EXECUTE(l_fund_cur_id);
1494:
1495: LOOP
1496: -- Fetch the ccid's from Gl_Code_Combinations
1497: trace(C_STATE_LEVEL, l_procedure_name, 'FETCH_ROWS');
1498: IF DBMS_SQL.FETCH_ROWS(l_fund_cur_id) = 0 THEN
1499: trace(C_STATE_LEVEL, l_procedure_name, 'EXIT');
1500: EXIT;