APPS.IGS_FI_BILL_EXTRACT dependencies on FND_LOOKUP_VALUES

Line 202: FROM fnd_lookup_values

198: CURSOR cur_bill_to_addr_usage (
199: cp_c_site_usg_type_cd IN VARCHAR2
200: ) IS
201: SELECT 'Y' found_bill_to_addr_usage
202: FROM fnd_lookup_values
203: WHERE lookup_type = 'PARTY_SITE_USE_CODE'
204: AND lookup_code = cp_c_site_usg_type_cd
205: AND view_application_id = 222
206: AND security_group_id = 0

Line 239: l_v_bill_usg_lkp_type fnd_lookup_values.lookup_type%TYPE := 'PARTY_SITE_USE_CODE';

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:
243: PROCEDURE bill_the_person (