APPS.FA_RECLASS_UTIL_PVT dependencies on FA_CATEGORIES

Line 121: from fa_categories

117: -- both categories must be capitalized or expensed types
118: --old values
119: select capitalize_flag, category_type
120: into v_old_cap_flag, v_old_cat_type
121: from fa_categories
122: where category_id = p_old_cat_id;
123:
124: -- new values
125: select capitalize_flag, category_type

Line 127: from fa_categories

123:
124: -- new values
125: select capitalize_flag, category_type
126: into v_new_cap_flag, v_new_cat_type
127: from fa_categories
128: where category_id = p_new_cat_id;
129: --
130: if v_old_cap_flag = 'YES' then
131: if v_new_cap_flag = 'NO' then

Line 155: fa_categories b

151: select count(*) into v_count
152: from dual
153: where exists ( select 'x'
154: from fa_additions a,
155: fa_categories b
156: where a.asset_id = p_asset_id
157: and a.lease_id = p_Lease_Id
158: and a.asset_category_id = b.category_id
159: and b.category_type = 'LEASEHOLD IMPROVEMENT');

Line 972: h_table_name varchar2(30) := 'FA_CATEGORIES_B';

968: h_mesg_str varchar2(2000);
969:
970: --
971: h_table_id number;
972: h_table_name varchar2(30) := 'FA_CATEGORIES_B';
973:
974: h_ccid_col_name varchar2(100) := 'CATEGORY_ID';
975: h_flex_code varchar2(10) := 'CAT#';
976: h_appl_id number := 140;