APPS.OKL_TBC_DEFINITIONS_PUB dependencies on OKL_TAX_ATTR_DEFINITIONS

Line 14: FROM OKL_TAX_ATTR_DEFINITIONS

10: ) RETURN VARCHAR2 IS
11:
12: CURSOR l_checkduplicate_tbc_csr(cp_tax_attribute_def_id IN VARCHAR2) IS
13: SELECT result_code
14: FROM OKL_TAX_ATTR_DEFINITIONS
15: WHERE result_type_code = 'TBC_CODE'
16: AND nvl(TRY_ID, -99999) = nvl(p_tbcv_rec.TRY_ID,-99999)
17: AND nvl(STY_ID, -99999) = nvl(p_tbcv_rec.STY_ID,-99999)
18: AND nvl(BOOK_CLASS_CODE,'XXXXX') = nvl(p_tbcv_rec.BOOK_CLASS_CODE,'XXXXX')

Line 25: FROM OKL_TAX_ATTR_DEFINITIONS

21: AND nvl(EXPIRE_FLAG,'N')<> 'Y' ;
22:
23: CURSOR l_checkduplicate_pc_csr(cp_tax_attribute_def_id IN VARCHAR2) IS
24: SELECT result_code
25: FROM OKL_TAX_ATTR_DEFINITIONS
26: WHERE result_type_code = 'PC_CODE'
27: AND nvl(PURCHASE_OPTION_CODE,'XXXXX') = nvl(p_tbcv_rec.PURCHASE_OPTION_CODE,'XXXXX')
28: AND nvl(STY_ID, -99999) = nvl(p_tbcv_rec.STY_ID,-99999)
29: AND nvl(INT_DISCLOSED_CODE,'N') = nvl(p_tbcv_rec.INT_DISCLOSED_CODE,'N')

Line 39: FROM OKL_TAX_ATTR_DEFINITIONS

35: AND nvl(EXPIRE_FLAG,'N')<> 'Y' ;
36:
37: CURSOR l_checkduplicate_ufc_csr(cp_tax_attribute_def_id IN VARCHAR2) IS
38: SELECT result_code
39: FROM OKL_TAX_ATTR_DEFINITIONS
40: WHERE result_type_code = 'UFC_CODE'
41: AND nvl(PURCHASE_OPTION_CODE,'XXXXX') = nvl(p_tbcv_rec.PURCHASE_OPTION_CODE,'XXXXX')
42: AND nvl(PDT_ID, -99999) = nvl(p_tbcv_rec.PDT_ID,-99999)
43: AND nvl(STY_ID, -99999) = nvl(p_tbcv_rec.STY_ID,-99999)