APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_PHONES

Line 192: from per_phones

188: (p_person_id number
189: ,p_type VARCHAR2
190: ,p_effective_date date) is
191: select 0,phone_id,date_from,date_to,phone_number,object_version_number
192: from per_phones
193: where parent_id=p_person_id
194: and parent_table='PER_ALL_PEOPLE_F'
195: and phone_type=p_type
196: and p_effective_date between date_from and nvl(date_to,p_effective_date)

Line 199: from per_phones

195: and phone_type=p_type
196: and p_effective_date between date_from and nvl(date_to,p_effective_date)
197: UNION
198: select months_between(p_effective_date,date_to),phone_id,date_from,date_to,phone_number,object_version_number
199: from per_phones
200: where parent_id=p_person_id
201: and parent_table='PER_ALL_PEOPLE_F'
202: and phone_type=p_type
203: and p_effective_date>date_to

Line 206: from per_phones

202: and phone_type=p_type
203: and p_effective_date>date_to
204: UNION
205: select months_between(date_from,p_effective_date),phone_id,date_from,date_to,phone_number,object_version_number
206: from per_phones
207: where parent_id=p_person_id
208: and parent_table='PER_ALL_PEOPLE_F'
209: and phone_type=p_type
210: and p_effective_date

Line 214: ,phone_id per_phones.phone_id%type

210: and p_effective_date 211: order by 1;
212: --
213: type phn_typ is record (dummy number
214: ,phone_id per_phones.phone_id%type
215: ,date_from per_phones.date_from%type
216: ,date_to per_phones.date_to%type
217: ,phone_number per_phones.phone_number%type
218: ,object_version_number per_phones.object_version_number%type);

Line 215: ,date_from per_phones.date_from%type

211: order by 1;
212: --
213: type phn_typ is record (dummy number
214: ,phone_id per_phones.phone_id%type
215: ,date_from per_phones.date_from%type
216: ,date_to per_phones.date_to%type
217: ,phone_number per_phones.phone_number%type
218: ,object_version_number per_phones.object_version_number%type);
219: phn_rec phn_typ;

Line 216: ,date_to per_phones.date_to%type

212: --
213: type phn_typ is record (dummy number
214: ,phone_id per_phones.phone_id%type
215: ,date_from per_phones.date_from%type
216: ,date_to per_phones.date_to%type
217: ,phone_number per_phones.phone_number%type
218: ,object_version_number per_phones.object_version_number%type);
219: phn_rec phn_typ;
220: --

Line 217: ,phone_number per_phones.phone_number%type

213: type phn_typ is record (dummy number
214: ,phone_id per_phones.phone_id%type
215: ,date_from per_phones.date_from%type
216: ,date_to per_phones.date_to%type
217: ,phone_number per_phones.phone_number%type
218: ,object_version_number per_phones.object_version_number%type);
219: phn_rec phn_typ;
220: --
221: cursor csr_assignment_details

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

214: ,phone_id per_phones.phone_id%type
215: ,date_from per_phones.date_from%type
216: ,date_to per_phones.date_to%type
217: ,phone_number per_phones.phone_number%type
218: ,object_version_number per_phones.object_version_number%type);
219: phn_rec phn_typ;
220: --
221: cursor csr_assignment_details
222: (p_assignment_id number