APPS.OKL_TBC_PVT dependencies on ZX_FC_BUSINESS_CATEGORIES_V

Line 591: FROM zx_fc_business_categories_v

587: l_dummy_var VARCHAR2(1) := '?' ;
588:
589: CURSOR okl_tbc_res_code_fk_csr (p_lookup_code IN VARCHAR2) IS
590: SELECT 'x'
591: FROM zx_fc_business_categories_v
592: WHERE classification_code = p_lookup_code;
593:
594: CURSOR okl_pc_res_code_fk_csr (p_lookup_code IN VARCHAR2) IS
595: SELECT 'x'

Line 629: 'ZX_FC_BUSINESS_CATEGORIES_V');

625: 'result_code',
626: g_child_table_token ,
627: 'OKL_TAX_ATTR_DEFINITIONS',
628: g_parent_table_token ,
629: 'ZX_FC_BUSINESS_CATEGORIES_V');
630: l_return_status := OKC_API.G_RET_STS_ERROR;
631:
632: END IF;
633: ELSIF (p_tbcv_rec.result_type_code = 'PC_CODE')

Line 1952: FROM zx_fc_business_categories_v

1948: l_okl_tbcv_term_qrcode okl_tbcv_term_qrcode_fk_csr%ROWTYPE;
1949:
1950: CURSOR okl_tbcv_res_code_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1951: SELECT 'x'
1952: FROM zx_fc_business_categories_v
1953: WHERE classification_code = p_lookup_code;
1954: --AND lookup_type = p_lookup_type;
1955: l_okl_tbcv_res_code okl_tbcv_res_code_fk_csr%ROWTYPE;
1956:

Line 2233: FROM zx_fc_business_categories_v

2229: -- modified by dcshanmu for eBTax project - modification end
2230:
2231: CURSOR okl_tbc_res_code_fk_csr (p_lookup_code IN VARCHAR2) IS
2232: SELECT classification_name
2233: FROM zx_fc_business_categories_v
2234: WHERE classification_code = p_lookup_code;
2235:
2236: CURSOR okl_pc_res_code_fk_csr (p_lookup_code IN VARCHAR2) IS
2237: SELECT classification_name