APPS.XLA_TB_REPORT_PVT dependencies on XLA_LOOKUPS

Line 1482: FROM xla_lookups xlc, xla_lookups xls

1478: SELECT xlc.meaning
1479: ,xls.meaning
1480: INTO l_cust_meaning
1481: ,l_supp_meaning
1482: FROM xla_lookups xlc, xla_lookups xls
1483: WHERE xlc.lookup_type = 'XLA_PARTY_TYPE'
1484: AND xlc.lookup_code = 'C'
1485: AND xls.lookup_type = 'XLA_PARTY_TYPE'
1486: AND xls.lookup_code = 'S';

Line 1769: FROM xla_lookups

1765: IF p_show_trx_detail_flag IS NOT NULL THEN
1766:
1767: SELECT meaning
1768: INTO p_show_trx_detail_dsp
1769: FROM xla_lookups
1770: WHERE lookup_code = p_show_trx_detail_flag
1771: AND lookup_type = 'XLA_YES_NO';
1772:
1773: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1788: FROM xla_lookups

1784: IF p_incl_write_off_flag IS NOT NULL THEN
1785:
1786: SELECT meaning
1787: INTO p_incl_write_off_dsp
1788: FROM xla_lookups
1789: WHERE lookup_code = p_incl_write_off_flag
1790: AND lookup_type = 'XLA_YES_NO';
1791:
1792: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1872: FROM xla_lookups

1868: IF p_acct_balance IS NOT NULL THEN
1869:
1870: SELECT meaning
1871: INTO p_acct_balance_dsp
1872: FROM xla_lookups
1873: WHERE lookup_type = 'XLA_TB_ACCT_BALANCE'
1874: AND lookup_code = p_acct_balance;
1875:
1876: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 2762: l_init_balance_dsp xla_lookups.meaning%TYPE;

2758: FUNCTION get_upg_select_clause
2759: RETURN VARCHAR2 IS
2760:
2761: l_upg_sql VARCHAR2(32000);
2762: l_init_balance_dsp xla_lookups.meaning%TYPE;
2763: l_ledger_cols VARCHAR2(1000);
2764:
2765: l_seg_desc_column VARCHAR2(32000);
2766: l_seg_desc_from VARCHAR2(32000);

Line 2820: FROM xla_lookups

2816: -- Replace $initial_balance$ with 'Initial Balance'
2817: --
2818: SELECT meaning
2819: INTO l_init_balance_dsp
2820: FROM xla_lookups
2821: WHERE lookup_type = 'XLA_TB_TRX_TYPE';
2822:
2823: l_upg_sql := REPLACE (l_upg_sql,'$initial_balance$',l_init_balance_dsp);
2824:

Line 2911: FROM xla_lookups

2907: l_source_sql := C_TB_SOURCE_SQL||' UNION ALL '||C_TB_WRITE_OFF_SQL ;
2908:
2909: SELECT meaning
2910: INTO l_write_off
2911: FROM xla_lookups
2912: WHERE lookup_type = 'XLA_ACCOUNTING_CLASS'
2913: AND lookup_code = 'WRITE_OFF';
2914:
2915: l_source_sql := REPLACE(l_source_sql, '$write_off$', l_write_off);