APPS.FA_RECLASS_UTIL_PVT dependencies on FA_CATEGORIES

Line 124: from fa_categories

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

Line 130: from fa_categories

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

Line 160: fa_categories b

156: select 1 into v_count
157: from dual
158: where exists ( select 'x'
159: from fa_additions a,
160: fa_categories b
161: where a.asset_id = p_asset_id
162: and a.lease_id = p_Lease_Id
163: and a.asset_category_id = b.category_id
164: and b.category_type = 'LEASEHOLD IMPROVEMENT');

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

998: h_mesg_str varchar2(2000);
999:
1000: --
1001: h_table_id number;
1002: h_table_name varchar2(30) := 'FA_CATEGORIES_B';
1003:
1004: h_ccid_col_name varchar2(100) := 'CATEGORY_ID';
1005: h_flex_code varchar2(10) := 'CAT#';
1006: h_appl_id number := 140;