APPS.GL_MC_INFO dependencies on GL_LEDGER_BSV_GT

Line 2336: FROM gl_ledger_bsv_gt

2332: INTO l_status
2333: FROM dual
2334: WHERE EXISTS
2335: (SELECT 'x'
2336: FROM gl_ledger_bsv_gt
2337: WHERE ledger_id = n_ledger_id);
2338: EXCEPTION
2339: WHEN NO_DATA_FOUND THEN
2340: l_status := 'Initialize';

Line 2371: INSERT INTO GL_LEDGER_BSV_GT

2367:
2368: IF (nvl(l_fv_type,'X') <> 'F')
2369: THEN
2370:
2371: INSERT INTO GL_LEDGER_BSV_GT
2372: ( FLEX_VALUE
2373: ,DESCRIPTION
2374: ,LEDGER_ID
2375: )

Line 2385: l_insert_statement(l_line_num) := 'INSERT INTO gl_ledger_bsv_gt ';

2381: WHERE FlexValues.FLEX_VALUE_SET_ID = Ledgers.bal_seg_value_set_id
2382: AND Ledgers.ledger_id = n_ledger_id
2383: AND FlexValues.SUMMARY_FLAG = 'N';
2384: ELSE
2385: l_insert_statement(l_line_num) := 'INSERT INTO gl_ledger_bsv_gt ';
2386: l_line_num := l_line_num + 1;
2387: l_insert_statement(l_line_num) := '(FLEX_VALUE,DESCRIPTION,LEDGER_ID)';
2388: l_line_num := l_line_num + 1;
2389: l_insert_statement(l_line_num) := 'SELECT '||l_fv_col||',';