APPS.XLA_TB_REPORT_PVT dependencies on XLA_LOOKUPS

Line 1496: FROM xla_lookups xlc, xla_lookups xls

1492: SELECT xlc.meaning
1493: ,xls.meaning
1494: INTO l_cust_meaning
1495: ,l_supp_meaning
1496: FROM xla_lookups xlc, xla_lookups xls
1497: WHERE xlc.lookup_type = 'XLA_PARTY_TYPE'
1498: AND xlc.lookup_code = 'C'
1499: AND xls.lookup_type = 'XLA_PARTY_TYPE'
1500: AND xls.lookup_code = 'S';

Line 1783: FROM xla_lookups

1779: IF p_show_trx_detail_flag IS NOT NULL THEN
1780:
1781: SELECT meaning
1782: INTO p_show_trx_detail_dsp
1783: FROM xla_lookups
1784: WHERE lookup_code = p_show_trx_detail_flag
1785: AND lookup_type = 'XLA_YES_NO';
1786:
1787: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1802: FROM xla_lookups

1798: IF p_incl_write_off_flag IS NOT NULL THEN
1799:
1800: SELECT meaning
1801: INTO p_incl_write_off_dsp
1802: FROM xla_lookups
1803: WHERE lookup_code = p_incl_write_off_flag
1804: AND lookup_type = 'XLA_YES_NO';
1805:
1806: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1886: FROM xla_lookups

1882: IF p_acct_balance IS NOT NULL THEN
1883:
1884: SELECT meaning
1885: INTO p_acct_balance_dsp
1886: FROM xla_lookups
1887: WHERE lookup_type = 'XLA_TB_ACCT_BALANCE'
1888: AND lookup_code = p_acct_balance;
1889:
1890: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 2563: l_init_balance_dsp xla_lookups.meaning%TYPE;

2559: FUNCTION get_upg_select_clause
2560: RETURN VARCHAR2 IS
2561:
2562: l_upg_sql VARCHAR2(32000);
2563: l_init_balance_dsp xla_lookups.meaning%TYPE;
2564: l_ledger_cols VARCHAR2(1000);
2565:
2566: l_balancing_segment VARCHAR2(80);
2567: l_account_segment VARCHAR2(80);

Line 2635: FROM xla_lookups

2631: -- Replace $initial_balance$ with 'Initial Balance'
2632: --
2633: SELECT meaning
2634: INTO l_init_balance_dsp
2635: FROM xla_lookups
2636: WHERE lookup_type = 'XLA_TB_TRX_TYPE';
2637:
2638: l_upg_sql := REPLACE (l_upg_sql,'$initial_balance$',l_init_balance_dsp);
2639:

Line 2799: FROM xla_lookups

2795: l_source_sql := C_TB_SOURCE_SQL||' UNION ALL '||C_TB_WRITE_OFF_SQL ;
2796:
2797: SELECT meaning
2798: INTO l_write_off
2799: FROM xla_lookups
2800: WHERE lookup_type = 'XLA_ACCOUNTING_CLASS'
2801: AND lookup_code = 'WRITE_OFF';
2802:
2803: l_source_sql := REPLACE(l_source_sql, '$write_off$', l_write_off);