DBA Data[Home] [Help]

APPS.IGS_FI_BILL_EXTRACT dependencies on FND_PROFILE_OPTIONS_VL

Line 228: FROM fnd_profile_options_vl

224: -- Added as part of the Bug 3804379
225: --
226: CURSOR cur_usr_profl_name IS
227: SELECT user_profile_option_name
228: FROM fnd_profile_options_vl
229: WHERE (profile_option_name LIKE 'IGS_REMIT_TO_ADD_USG');
230: --
231: rec_cur_person_id_group cur_person_id_group%ROWTYPE;
232: rec_cur_remit_addr cur_remit_addr%ROWTYPE;

Line 238: l_v_usr_profl_name fnd_profile_options_vl.user_profile_option_name%TYPE := NULL;

234: --
235:
236: l_v_manage_acc igs_fi_control_all.manage_accounts%TYPE := NULL;
237: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
238: l_v_usr_profl_name fnd_profile_options_vl.user_profile_option_name%TYPE := NULL;
239: l_v_bill_usg_lkp_type fnd_lookup_values.lookup_type%TYPE := 'PARTY_SITE_USE_CODE';
240: l_n_use_num NUMBER;
241:
242: