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

Line 781: from per_people_extra_info pei

777:
778: -- JH EHRI may need date factored in and order by (test)
779: Cursor c_extra_info_id is
780: select pei.person_extra_info_id
781: from per_people_extra_info pei
782: where pei.person_id = p_sr_person_id
783: and pei.information_type = 'GHR_US_PER_SERVICE_OBLIGATION'
784: order by pei.person_extra_info_id;
785:

Line 793: l_PEOPEI_DATA PER_PEOPLE_EXTRA_INFO%ROWTYPE;

789: where user_table_id = p_user_table_id;
790:
791:
792: l_proc varchar2(30) := 'get_from_history_peopei';
793: l_PEOPEI_DATA PER_PEOPLE_EXTRA_INFO%ROWTYPE;
794: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;
795: l_type_of_employment per_people_extra_info.pei_information4%TYPE;
796: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
797: l_session ghr_history_api.g_session_var_type;

Line 794: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;

790:
791:
792: l_proc varchar2(30) := 'get_from_history_peopei';
793: l_PEOPEI_DATA PER_PEOPLE_EXTRA_INFO%ROWTYPE;
794: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;
795: l_type_of_employment per_people_extra_info.pei_information4%TYPE;
796: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
797: l_session ghr_history_api.g_session_var_type;
798: l_extra_info_id per_people_extra_info.person_extra_info_id%type;

Line 795: l_type_of_employment per_people_extra_info.pei_information4%TYPE;

791:
792: l_proc varchar2(30) := 'get_from_history_peopei';
793: l_PEOPEI_DATA PER_PEOPLE_EXTRA_INFO%ROWTYPE;
794: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;
795: l_type_of_employment per_people_extra_info.pei_information4%TYPE;
796: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
797: l_session ghr_history_api.g_session_var_type;
798: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
799: l_result varchar2(20);

Line 798: l_extra_info_id per_people_extra_info.person_extra_info_id%type;

794: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;
795: l_type_of_employment per_people_extra_info.pei_information4%TYPE;
796: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
797: l_session ghr_history_api.g_session_var_type;
798: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
799: l_result varchar2(20);
800: l_cnt number;
801: l_user_table_id number;
802: l_message_name varchar2(50);