APPS.IGIRX_IAC_PROJ dependencies on FA_SYSTEM_CONTROLS

Line 70: l_cat_struct fa_system_controls.category_flex_structure%TYPE;

66: -- variables
67: l_login_id NUMBER := fnd_profile.value('LOGIN_ID');
68: l_user_id NUMBER := fnd_profile.value('USER_ID');
69:
70: l_cat_struct fa_system_controls.category_flex_structure%TYPE;
71: l_assetkey_struct fa_system_controls.asset_key_flex_structure%TYPE;
72:
73: l_get_proj c_get_proj%ROWTYPE;
74: l_sob_id fa_book_controls.set_of_books_id%TYPE;

Line 71: l_assetkey_struct fa_system_controls.asset_key_flex_structure%TYPE;

67: l_login_id NUMBER := fnd_profile.value('LOGIN_ID');
68: l_user_id NUMBER := fnd_profile.value('USER_ID');
69:
70: l_cat_struct fa_system_controls.category_flex_structure%TYPE;
71: l_assetkey_struct fa_system_controls.asset_key_flex_structure%TYPE;
72:
73: l_get_proj c_get_proj%ROWTYPE;
74: l_sob_id fa_book_controls.set_of_books_id%TYPE;
75: l_currency_code gl_sets_of_books.currency_code%TYPE;

Line 139: FROM fa_system_controls;

135: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Entered inner procedure');
136: -- get the category and asset key flex structures
137: SELECT category_flex_structure, asset_key_flex_structure
138: INTO l_cat_struct, l_assetkey_struct
139: FROM fa_system_controls;
140:
141: -- get the book type code for the projection
142: OPEN c_get_proj(p_projection_id);
143: FETCH c_get_proj INTO l_get_proj;