APPS.XLA_TB_AP_REPORT_PVT dependencies on XLA_LOOKUPS

Line 1661: FROM xla_lookups xlc, xla_lookups xls

1657: SELECT xlc.meaning
1658: ,xls.meaning
1659: INTO l_cust_meaning
1660: ,l_supp_meaning
1661: FROM xla_lookups xlc, xla_lookups xls
1662: WHERE xlc.lookup_type = 'XLA_PARTY_TYPE'
1663: AND xlc.lookup_code = 'C'
1664: AND xls.lookup_type = 'XLA_PARTY_TYPE'
1665: AND xls.lookup_code = 'S';

Line 1948: FROM xla_lookups

1944: IF p_show_trx_detail_flag IS NOT NULL THEN
1945:
1946: SELECT meaning
1947: INTO p_show_trx_detail_dsp
1948: FROM xla_lookups
1949: WHERE lookup_code = p_show_trx_detail_flag
1950: AND lookup_type = 'XLA_YES_NO';
1951:
1952: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1967: FROM xla_lookups

1963: IF p_incl_write_off_flag IS NOT NULL THEN
1964:
1965: SELECT meaning
1966: INTO p_incl_write_off_dsp
1967: FROM xla_lookups
1968: WHERE lookup_code = p_incl_write_off_flag
1969: AND lookup_type = 'XLA_YES_NO';
1970:
1971: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 2051: FROM xla_lookups

2047: IF p_acct_balance IS NOT NULL THEN
2048:
2049: SELECT meaning
2050: INTO p_acct_balance_dsp
2051: FROM xla_lookups
2052: WHERE lookup_type = 'XLA_TB_ACCT_BALANCE'
2053: AND lookup_code = p_acct_balance;
2054:
2055: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 2068: FROM xla_lookups

2064: END IF;
2065:
2066: SELECT meaning
2067: INTO P_REPORT_MODE_DSP
2068: FROM xla_lookups
2069: WHERE lookup_type = 'XLA_REPORT_LEVEL'
2070: AND lookup_code = NVL(P_REPORT , 'D');
2071:
2072: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 2481: l_init_balance_dsp xla_lookups.meaning%TYPE;

2477: FUNCTION get_upg_select_clause
2478: RETURN VARCHAR2 IS
2479:
2480: l_upg_sql VARCHAR2(32000);
2481: l_init_balance_dsp xla_lookups.meaning%TYPE;
2482: l_ledger_cols VARCHAR2(1000);
2483: l_balancing_segment VARCHAR2(80);
2484: l_account_segment VARCHAR2(80);
2485: l_costcenter_segment VARCHAR2(80);

Line 2553: FROM xla_lookups

2549: -- Replace $initial_balance$ with 'Initial Balance'
2550: --
2551: SELECT meaning
2552: INTO l_init_balance_dsp
2553: FROM xla_lookups
2554: WHERE lookup_type = 'XLA_TB_TRX_TYPE';
2555:
2556: l_upg_sql := REPLACE (l_upg_sql,'$initial_balance$',l_init_balance_dsp);
2557:

Line 2817: FROM xla_lookups

2813: l_source_sql := C_TB_SOURCE_SQL||' UNION ALL '||C_TB_WRITE_OFF_SQL ;
2814:
2815: SELECT meaning
2816: INTO l_write_off
2817: FROM xla_lookups
2818: WHERE lookup_type = 'XLA_ACCOUNTING_CLASS'
2819: AND lookup_code = 'WRITE_OFF';
2820:
2821: l_source_sql := REPLACE(l_source_sql, '$write_off$', l_write_off);