eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_BULK_ENROLL_UTIL dependencies on PER_PHONES

Line 499: --Bug6723416 :Modified the cursor to fetch phone number from per_phones

495: AND trunc(sysdate) BETWEEN paf.effective_start_date AND paf.effective_end_date
496: AND ppf.person_id = p_person_id
497: AND paf.assignment_id = p_assignment_id;*/
498:
499: --Bug6723416 :Modified the cursor to fetch phone number from per_phones
500:
501: /*CURSOR csr_get_assignment_details IS
502: SELECT PPH.PHONE_NUMBER work_telephone,
503: paf.organization_id,

Line 508: per_phones pph

504: ppf.email_address
505: FROM
506: per_all_people_f ppf,
507: per_all_assignments_f paf ,
508: per_phones pph
509: WHERE
510: ppf.person_id = paf.person_id
511: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
512: AND trunc(sysdate) BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 529: per_phones pph,

525: pfax.PHONE_NUMBER fax_number
526: FROM
527: per_all_people_f ppf,
528: per_all_assignments_f paf ,
529: per_phones pph,
530: per_phones pfax
531: WHERE
532: ppf.person_id = paf.person_id
533: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 530: per_phones pfax

526: FROM
527: per_all_people_f ppf,
528: per_all_assignments_f paf ,
529: per_phones pph,
530: per_phones pfax
531: WHERE
532: ppf.person_id = paf.person_id
533: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
534: AND trunc(sysdate) BETWEEN paf.effective_start_date AND paf.effective_end_date