DBA Data[Home] [Help]

APPS.ZX_TDS_PROCESS_CEC_PVT dependencies on AR_LOOKUPS

Line 2408: from ar_lookups

2404: p_error_buffer OUT NOCOPY VARCHAR2) is
2405:
2406: cursor loc_qualifier_csr(c_trx_date DATE) is
2407: select lookup_code
2408: from ar_lookups
2409: where LOOKUP_TYPE = 'ARTAXVDR_LOC_QUALIFIER'
2410: and enabled_flag = 'Y'
2411: and trunc(c_trx_date) between
2412: trunc(start_date_active) and

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

2424: l_exception_result BOOLEAN;
2425:
2426: l_total_lines NUMBER;
2427:
2428: TYPE qualifier_tbl_type is TABLE of ar_lookups.lookup_code%TYPE index by binary_integer;
2429: l_qualifier_tbl qualifier_tbl_type;
2430: l_code_tax_type VARCHAR2(30);
2431: l_lookup_code ar_lookups.lookup_code%TYPE;
2432: l_tax_compiled_constraint VARCHAR2(2000);

Line 2431: l_lookup_code ar_lookups.lookup_code%TYPE;

2427:
2428: TYPE qualifier_tbl_type is TABLE of ar_lookups.lookup_code%TYPE index by binary_integer;
2429: l_qualifier_tbl qualifier_tbl_type;
2430: l_code_tax_type VARCHAR2(30);
2431: l_lookup_code ar_lookups.lookup_code%TYPE;
2432: l_tax_compiled_constraint VARCHAR2(2000);
2433: l_tax_compiled_condition VARCHAR2(2000);
2434: l_tax_compiled_exception VARCHAR2(2000);
2435: l_true_compiled_action VARCHAR2(4000);