DBA Data[Home] [Help]

APPS.ZX_TDS_PROCESS_CEC_PVT dependencies on AR_LOOKUPS

Line 2414: from ar_lookups

2410: p_error_buffer OUT NOCOPY VARCHAR2) is
2411:
2412: cursor loc_qualifier_csr(c_trx_date DATE) is
2413: select lookup_code
2414: from ar_lookups
2415: where LOOKUP_TYPE = 'ARTAXVDR_LOC_QUALIFIER'
2416: and enabled_flag = 'Y'
2417: and trunc(c_trx_date) between
2418: trunc(start_date_active) and

Line 2434: TYPE qualifier_tbl_type is TABLE of ar_lookups.lookup_code%TYPE index by binary_integer;

2430: l_exception_result BOOLEAN;
2431:
2432: l_total_lines NUMBER;
2433:
2434: TYPE qualifier_tbl_type is TABLE of ar_lookups.lookup_code%TYPE index by binary_integer;
2435: l_qualifier_tbl qualifier_tbl_type;
2436: l_code_tax_type VARCHAR2(30);
2437: l_lookup_code ar_lookups.lookup_code%TYPE;
2438: l_tax_compiled_constraint VARCHAR2(2500);

Line 2437: l_lookup_code ar_lookups.lookup_code%TYPE;

2433:
2434: TYPE qualifier_tbl_type is TABLE of ar_lookups.lookup_code%TYPE index by binary_integer;
2435: l_qualifier_tbl qualifier_tbl_type;
2436: l_code_tax_type VARCHAR2(30);
2437: l_lookup_code ar_lookups.lookup_code%TYPE;
2438: l_tax_compiled_constraint VARCHAR2(2500);
2439: l_tax_compiled_condition VARCHAR2(2500);
2440: l_tax_compiled_exception VARCHAR2(2500);
2441: l_true_compiled_action VARCHAR2(4000);