APPS.GHR_CPDF_EHRIS dependencies on PER_PHONES

Line 333: FROM per_phones pho

329:
330: -- JH New EHRI Phones
331: CURSOR cur_phones IS
332: SELECT pho.phone_number, pho.phone_type
333: FROM per_phones pho
334: WHERE pho.parent_table = 'PER_ALL_PEOPLE_F'
335: AND pho.parent_id = g_person_id
336: AND pho.phone_type IN ('W1','H1','M');
337:

Line 344: ,per_phones pho

340: SELECT contact.last_name, contact.first_name, contact.middle_names, contact.suffix
341: ,pho.phone_number, rel.date_start
342: FROM per_contact_relationships_v2 rel
343: ,per_all_people contact
344: ,per_phones pho
345: WHERE rel.person_id = g_person_id
346: AND contact_type in ('EMRG','EC')
347: AND rel.contact_person_id = contact.person_id
348: AND p_sr_report_date between contact.effective_start_date AND contact.effective_end_date

Line 354: FROM per_phones pho2

350: AND pho.parent_id(+) = contact.person_id
351: AND p_sr_report_date BETWEEN NVL(pho.date_from,p_sr_report_date) AND NVL(pho.date_to,p_sr_report_date)
352: AND ((pho.phone_type = 'M'
353: AND NOT EXISTS (SELECT 1
354: FROM per_phones pho2
355: WHERE pho2.parent_id = pho.parent_id
356: AND pho2.phone_type IN ('H1','W1')
357: )
358: )

Line 361: FROM per_phones pho2

357: )
358: )
359: OR (pho.phone_type = 'W1'
360: AND NOT EXISTS (SELECT 1
361: FROM per_phones pho2
362: WHERE pho2.parent_id = pho.parent_id
363: AND pho2.phone_type = 'H1'
364: )
365: )