APPS.XLA_TB_AP_REPORT_PVT dependencies on XLA_LOOKUPS

Line 1188: FROM xla_lookups xlc, xla_lookups xls

1184: SELECT xlc.meaning
1185: ,xls.meaning
1186: INTO l_cust_meaning
1187: ,l_supp_meaning
1188: FROM xla_lookups xlc, xla_lookups xls
1189: WHERE xlc.lookup_type = 'XLA_PARTY_TYPE'
1190: AND xlc.lookup_code = 'C'
1191: AND xls.lookup_type = 'XLA_PARTY_TYPE'
1192: AND xls.lookup_code = 'S';

Line 1475: FROM xla_lookups

1471: IF p_show_trx_detail_flag IS NOT NULL THEN
1472:
1473: SELECT meaning
1474: INTO p_show_trx_detail_dsp
1475: FROM xla_lookups
1476: WHERE lookup_code = p_show_trx_detail_flag
1477: AND lookup_type = 'XLA_YES_NO';
1478:
1479: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1494: FROM xla_lookups

1490: IF p_incl_write_off_flag IS NOT NULL THEN
1491:
1492: SELECT meaning
1493: INTO p_incl_write_off_dsp
1494: FROM xla_lookups
1495: WHERE lookup_code = p_incl_write_off_flag
1496: AND lookup_type = 'XLA_YES_NO';
1497:
1498: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1578: FROM xla_lookups

1574: IF p_acct_balance IS NOT NULL THEN
1575:
1576: SELECT meaning
1577: INTO p_acct_balance_dsp
1578: FROM xla_lookups
1579: WHERE lookup_type = 'XLA_TB_ACCT_BALANCE'
1580: AND lookup_code = p_acct_balance;
1581:
1582: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 2181: l_init_balance_dsp xla_lookups.meaning%TYPE;

2177: FUNCTION get_upg_select_clause
2178: RETURN VARCHAR2 IS
2179:
2180: l_upg_sql VARCHAR2(32000);
2181: l_init_balance_dsp xla_lookups.meaning%TYPE;
2182: l_ledger_cols VARCHAR2(1000);
2183:
2184: l_seg_desc_column VARCHAR2(32000);
2185: l_seg_desc_from VARCHAR2(32000);

Line 2239: FROM xla_lookups

2235: -- Replace $initial_balance$ with 'Initial Balance'
2236: --
2237: SELECT meaning
2238: INTO l_init_balance_dsp
2239: FROM xla_lookups
2240: WHERE lookup_type = 'XLA_TB_TRX_TYPE';
2241:
2242: l_upg_sql := REPLACE (l_upg_sql,'$initial_balance$',l_init_balance_dsp);
2243:

Line 2330: FROM xla_lookups

2326: l_source_sql := C_TB_SOURCE_SQL||' UNION ALL '||C_TB_WRITE_OFF_SQL ;
2327:
2328: SELECT meaning
2329: INTO l_write_off
2330: FROM xla_lookups
2331: WHERE lookup_type = 'XLA_ACCOUNTING_CLASS'
2332: AND lookup_code = 'WRITE_OFF';
2333:
2334: l_source_sql := REPLACE(l_source_sql, '$write_off$', l_write_off);