APPS.BIM_PRODUCT_CATEG_PKG dependencies on BIM_DIMV_INTEREST_CODES
Line 13: FROM bim_dimv_interest_codes
9:
10: cursor c_get_pcode
11: IS
12: SELECT interest_code_id 13: FROM bim_dimv_interest_codes 14: WHERE interest_code = p_interest_code
15: AND parent_interest_code_id is NULL
16: AND interest_type_id = p_interest_type_id ;
17:
Line 22: FROM bim_dimv_interest_codes
18:
19: cursor c_get_scode
20: IS
21: SELECT interest_code_id 22: FROM bim_dimv_interest_codes 23: WHERE interest_code = p_interest_code
24: AND parent_interest_code_id is NOT NULL
25: AND interest_type_id = p_interest_type_id ;
26: