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.PQP_HROSS_INTEGRATION dependencies on PER_PEOPLE_EXTRA_INFO

Line 2467: FROM per_people_extra_info pei

2463: ,pei.pei_information4
2464: ,pei.pei_information5
2465: ,pei.object_version_number
2466: ,pei.person_extra_info_id
2467: FROM per_people_extra_info pei
2468: WHERE pei.person_id = c_person_id
2469: AND pei.information_type = c_information_type;
2470:
2471: l_OSS_pe csr_oss_pe%ROWTYPE;

Line 2492: l_oss_person_details per_people_extra_info.information_type%TYPE;

2488:
2489: SQLstmt Varchar2(2000);
2490: csr_igs csr_oss_t;
2491: l_oss_per_details oss_per_rec;
2492: l_oss_person_details per_people_extra_info.information_type%TYPE;
2493: l_person_extra_info_rec per_people_extra_info%ROWTYPE;
2494: --
2495: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'HR_DataPump_Per_XtraInfo';
2496: --

Line 2493: l_person_extra_info_rec per_people_extra_info%ROWTYPE;

2489: SQLstmt Varchar2(2000);
2490: csr_igs csr_oss_t;
2491: l_oss_per_details oss_per_rec;
2492: l_oss_person_details per_people_extra_info.information_type%TYPE;
2493: l_person_extra_info_rec per_people_extra_info%ROWTYPE;
2494: --
2495: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'HR_DataPump_Per_XtraInfo';
2496: --
2497: