DBA Data[Home] [Help]

APPS.OKL_TBC_PVT dependencies on ZX_FC_PRODUCT_CATEGORIES_V

Line 596: FROM zx_fc_product_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'
596: FROM zx_fc_product_categories_v
597: WHERE classification_code = p_lookup_code;
598:
599: CURSOR okl_ufc_res_code_fk_csr (p_lookup_code IN VARCHAR2) IS
600: SELECT 'x'

Line 649: 'ZX_FC_PRODUCT_CATEGORIES_V');

645: 'result_code',
646: g_child_table_token ,
647: 'OKL_TAX_ATTR_DEFINITIONS',
648: g_parent_table_token ,
649: 'ZX_FC_PRODUCT_CATEGORIES_V');
650: l_return_status := OKC_API.G_RET_STS_ERROR;
651:
652: END IF;
653: ELSIF (p_tbcv_rec.result_type_code = 'UFC_CODE')

Line 2238: FROM zx_fc_product_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
2238: FROM zx_fc_product_categories_v
2239: WHERE classification_code = p_lookup_code;
2240:
2241: CURSOR okl_ufc_res_code_fk_csr (p_lookup_code IN VARCHAR2) IS
2242: SELECT classification_name