APPS.IGS_FI_BILL_EXTRACT dependencies on FND_PROFILE

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:

Line 1392: FND_PROFILE.VALUE('IGS_REMIT_TO_ADD_USG')

1388: CLOSE cur_usr_profl_name;
1389: OPEN cur_remit_addr (
1390: p_n_remit_prty_site_id,
1391: p_d_due_dt,
1392: FND_PROFILE.VALUE('IGS_REMIT_TO_ADD_USG')
1393: );
1394: FETCH cur_remit_addr INTO rec_cur_remit_addr;
1395: IF (cur_remit_addr%NOTFOUND) THEN
1396: CLOSE cur_remit_addr;