APPS.IGI_IMP_IAC_WEBADI_PKG dependencies on FA_CATEGORIES_B_KFV

Line 49: FROM fa_categories_b_kfv

45: INTO l_count
46: FROM igi_imp_iac_interface_ctrl
47: WHERE book_type_code = n_book_code
48: AND category_id = (SELECT category_id
49: FROM fa_categories_b_kfv
50: WHERE concatenated_segments = n_category_desc);
51:
52: RETURN(l_count);
53: EXCEPTION

Line 73: FROM fa_categories_b_kfv

69: INTO l_tfr_stat
70: FROM igi_imp_iac_interface_ctrl
71: WHERE book_type_code = n_book_code
72: AND category_id = (SELECT category_id
73: FROM fa_categories_b_kfv
74: WHERE concatenated_segments = n_category_desc);
75:
76: RETURN(l_tfr_stat);
77: EXCEPTION

Line 102: FROM fa_categories_b_kfv

98: FROM fa_additions
99: WHERE asset_number = n_asset_number)
100: AND book_type_code = n_book_code
101: AND category_id = (SELECT category_id
102: FROM fa_categories_b_kfv
103: WHERE concatenated_segments = n_category_desc);
104:
105: RETURN(l_count);
106: EXCEPTION

Line 133: FROM fa_categories_b_kfv

129: WHERE asset_number = n_asset_number)
130: AND book_type_code = n_book_code
131: AND group_id = n_group_id
132: AND category_id = (SELECT category_id
133: FROM fa_categories_b_kfv
134: WHERE concatenated_segments = n_category_desc);
135:
136: RETURN(l_count);
137: EXCEPTION

Line 174: FROM fa_categories_b_kfv

170: FROM fa_additions
171: WHERE asset_number = p_asset_number)
172: AND book_type_code = p_book_code
173: AND category_id = (SELECT category_id
174: FROM fa_categories_b_kfv
175: WHERE concatenated_segments = p_category_desc);
176:
177: Cursor C_book_class( cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE) is
178: Select book_class