DBA Data[Home] [Help]

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_TAX_ATTR_DEFINITIONS

Line 3381: FROM okl_tax_attr_definitions

3377: sty_id ,
3378: book_class_code,
3379: tax_country_code,
3380: 'Y' select_yn -- All TBCs returned by this cursor are selected initially
3381: FROM okl_tax_attr_definitions
3382: WHERE (try_id = cp_try_id OR try_id IS NULL)
3383: AND RESULT_TYPE_CODE = 'TBC_CODE'
3384: AND NVL(expire_flag, 'N') = 'N';
3385:

Line 3398: l_tbc_code okl_tax_attr_definitions.RESULT_CODE%TYPE;

3394: i NUMBER;
3395: j NUMBER;
3396: k NUMBER;
3397: tbc_set_count NUMBER;
3398: l_tbc_code okl_tax_attr_definitions.RESULT_CODE%TYPE;
3399: -- l_tbc_code VARCHAR2(30);
3400: selected_count NUMBER;
3401: det_match_cnt NUMBER;
3402: l_selected_tbc_pos NUMBER;

Line 3869: FROM okl_tax_attr_definitions

3865: sale_lease_back_code,
3866: lease_purchased_code,
3867: tax_country_code,
3868: 'Y' select_yn -- All PCs returned by this cursor are selected initially
3869: FROM okl_tax_attr_definitions
3870: WHERE (sty_id = p_sty_id OR sty_id IS NULL)
3871: AND result_type_code = 'PC_CODE'
3872: AND NVL(expire_flag, 'N') = 'N';
3873:

Line 4516: FROM okl_tax_attr_definitions

4512: term_quote_type_code,
4513: term_quote_reason_code,
4514: tax_country_code,
4515: 'Y' select_yn -- all ufcs returned by this cursor are selected initially
4516: FROM okl_tax_attr_definitions
4517: WHERE (try_id = cp_try_id OR try_id IS NULL)
4518: AND RESULT_TYPE_CODE = 'UFC_CODE'
4519: AND NVL(expire_flag, 'N') = 'N';
4520: