APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_PHONES

Line 221: from per_phones

217: (p_person_id number
218: ,p_type VARCHAR2
219: ,p_effective_date date) is
220: select 0,phone_id,date_from,date_to,phone_number,object_version_number
221: from per_phones
222: where parent_id=p_person_id
223: and parent_table='PER_ALL_PEOPLE_F'
224: and phone_type=p_type
225: and p_effective_date between date_from and nvl(date_to,p_effective_date)

Line 228: from per_phones

224: and phone_type=p_type
225: and p_effective_date between date_from and nvl(date_to,p_effective_date)
226: UNION
227: select months_between(p_effective_date,date_to),phone_id,date_from,date_to,phone_number,object_version_number
228: from per_phones
229: where parent_id=p_person_id
230: and parent_table='PER_ALL_PEOPLE_F'
231: and phone_type=p_type
232: and p_effective_date>date_to

Line 235: from per_phones

231: and phone_type=p_type
232: and p_effective_date>date_to
233: UNION
234: select months_between(date_from,p_effective_date),phone_id,date_from,date_to,phone_number,object_version_number
235: from per_phones
236: where parent_id=p_person_id
237: and parent_table='PER_ALL_PEOPLE_F'
238: and phone_type=p_type
239: and p_effective_date

Line 243: ,phone_id per_phones.phone_id%type

239: and p_effective_date 240: order by 1;
241: --
242: type phn_typ is record (dummy number
243: ,phone_id per_phones.phone_id%type
244: ,date_from per_phones.date_from%type
245: ,date_to per_phones.date_to%type
246: ,phone_number per_phones.phone_number%type
247: ,object_version_number per_phones.object_version_number%type);

Line 244: ,date_from per_phones.date_from%type

240: order by 1;
241: --
242: type phn_typ is record (dummy number
243: ,phone_id per_phones.phone_id%type
244: ,date_from per_phones.date_from%type
245: ,date_to per_phones.date_to%type
246: ,phone_number per_phones.phone_number%type
247: ,object_version_number per_phones.object_version_number%type);
248: phn_rec phn_typ;

Line 245: ,date_to per_phones.date_to%type

241: --
242: type phn_typ is record (dummy number
243: ,phone_id per_phones.phone_id%type
244: ,date_from per_phones.date_from%type
245: ,date_to per_phones.date_to%type
246: ,phone_number per_phones.phone_number%type
247: ,object_version_number per_phones.object_version_number%type);
248: phn_rec phn_typ;
249: --

Line 246: ,phone_number per_phones.phone_number%type

242: type phn_typ is record (dummy number
243: ,phone_id per_phones.phone_id%type
244: ,date_from per_phones.date_from%type
245: ,date_to per_phones.date_to%type
246: ,phone_number per_phones.phone_number%type
247: ,object_version_number per_phones.object_version_number%type);
248: phn_rec phn_typ;
249: --
250: cursor csr_assignment_details

Line 247: ,object_version_number per_phones.object_version_number%type);

243: ,phone_id per_phones.phone_id%type
244: ,date_from per_phones.date_from%type
245: ,date_to per_phones.date_to%type
246: ,phone_number per_phones.phone_number%type
247: ,object_version_number per_phones.object_version_number%type);
248: phn_rec phn_typ;
249: --
250: cursor csr_assignment_details
251: (p_assignment_id number