APPS.JTF_RS_IMP_RES_PVT dependencies on PER_PHONES

Line 197: FROM per_phones per

193: l_asg_start_date DATE;
194:
195: CURSOR phone_cur(l_person_id NUMBER) IS
196: SELECT phone_number
197: FROM per_phones per
198: WHERE parent_table = 'PER_ALL_PEOPLE_F'
199: AND parent_id = l_person_id
200: AND phone_type = 'W1'
201: AND date_from = (SELECT MAX(date_from)

Line 202: FROM per_phones p2

198: WHERE parent_table = 'PER_ALL_PEOPLE_F'
199: AND parent_id = l_person_id
200: AND phone_type = 'W1'
201: AND date_from = (SELECT MAX(date_from)
202: FROM per_phones p2
203: WHERE parent_table = 'PER_ALL_PEOPLE_F'
204: AND parent_id = l_person_id
205: AND phone_type = 'W1' );
206:

Line 213: FROM per_phones per

209: -- Adding the cursors for mobile and pager (repuri 10/16/01)
210:
211: CURSOR mobile_cur(l_person_id NUMBER) IS
212: SELECT phone_number
213: FROM per_phones per
214: WHERE parent_table = 'PER_ALL_PEOPLE_F'
215: and parent_id = l_person_id
216: and phone_type = 'M'
217: and date_from = (SELECT MAX(date_from)

Line 218: FROM per_phones p2

214: WHERE parent_table = 'PER_ALL_PEOPLE_F'
215: and parent_id = l_person_id
216: and phone_type = 'M'
217: and date_from = (SELECT MAX(date_from)
218: FROM per_phones p2
219: WHERE parent_table = 'PER_ALL_PEOPLE_F'
220: AND parent_id = l_person_id
221: AND phone_type = 'M' );
222:

Line 227: FROM per_phones per

223: mobile_rec mobile_cur%rowtype;
224:
225: CURSOR pager_cur(l_person_id NUMBER) IS
226: SELECT phone_number
227: FROM per_phones per
228: WHERE parent_table = 'PER_ALL_PEOPLE_F'
229: and parent_id = l_person_id
230: and phone_type = 'P'
231: and date_from = (SELECT MAX(date_from)

Line 232: FROM per_phones p2

228: WHERE parent_table = 'PER_ALL_PEOPLE_F'
229: and parent_id = l_person_id
230: and phone_type = 'P'
231: and date_from = (SELECT MAX(date_from)
232: FROM per_phones p2
233: WHERE parent_table = 'PER_ALL_PEOPLE_F'
234: AND parent_id = l_person_id
235: AND phone_type = 'P' );
236: