162: c_date date)
163: IS
164: SELECT phone_number,
165: phone_type
166: FROM per_phones
167: WHERE parent_id = c_person_id
168: AND c_date BETWEEN date_from
169: AND nvl(date_to,end_Date)
170: AND parent_table = 'PER_ALL_PEOPLE_F';
175: l_full_name per_all_people_f.full_name%TYPE := '';
176: l_first_name per_all_people_f.first_name%TYPE := '';
177: l_middle_name per_all_people_f.middle_names%TYPE := '';
178: l_last_name per_all_people_f.last_name%TYPE := '';
179: l_phone per_phones.phone_number%TYPE := '';
180: l_extension varchar2(5) := '';
181: l_phone_type per_phones.phone_type%TYPE := '';
182: l_fax per_phones.phone_number%TYPE := '';
183: l_email per_all_people_f.email_address%TYPE := '';
177: l_middle_name per_all_people_f.middle_names%TYPE := '';
178: l_last_name per_all_people_f.last_name%TYPE := '';
179: l_phone per_phones.phone_number%TYPE := '';
180: l_extension varchar2(5) := '';
181: l_phone_type per_phones.phone_type%TYPE := '';
182: l_fax per_phones.phone_number%TYPE := '';
183: l_email per_all_people_f.email_address%TYPE := '';
184: l_title per_all_people_f.title%TYPE := '';
185:
178: l_last_name per_all_people_f.last_name%TYPE := '';
179: l_phone per_phones.phone_number%TYPE := '';
180: l_extension varchar2(5) := '';
181: l_phone_type per_phones.phone_type%TYPE := '';
182: l_fax per_phones.phone_number%TYPE := '';
183: l_email per_all_people_f.email_address%TYPE := '';
184: l_title per_all_people_f.title%TYPE := '';
185:
186: BEGIN