DBA Data[Home] [Help]

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: