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.PER_SIP_BUS dependencies on PER_ALL_PEOPLE_F

Line 366: from per_all_people_f

362: l_name varchar2(240);
363:
364: cursor csrPersonName is
365: select full_name
366: from per_all_people_f
367: where person_id=p_successor_id
368: and trunc(sysdate) between effective_start_date and effective_end_date;
369: --
370: Begin

Line 461: from per_all_people_f

457: l_name varchar2(240);
458:
459: cursor csrPersonName is
460: select full_name
461: from per_all_people_f
462: where person_id=p_successor_id
463: and trunc(sysdate) between effective_start_date and effective_end_date;
464:
465: cursor csrPlanDtls is

Line 480: per_all_people_f papf,

476: cursor csrPersonType is
477: SELECT
478: ppt.system_person_type
479: FROM
480: per_all_people_f papf,
481: per_person_type_usages_f ptu,
482: per_person_types ppt
483: where papf.person_id=p_successor_id
484: and papf.person_id=ptu.person_id

Line 656: from per_all_people_f

652: l_name varchar2(240);
653:
654: cursor csrPersonName is
655: select full_name
656: from per_all_people_f
657: where person_id=p_successor_id
658: and trunc(sysdate) between effective_start_date and effective_end_date;
659:
660: cursor csrPlanDtls is