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 768: from per_people_extra_info pei

764:
765: -- JH EHRI may need date factored in and order by (test)
766: Cursor c_extra_info_id is
767: select pei.person_extra_info_id
768: from per_people_extra_info pei
769: where pei.person_id = p_sr_person_id
770: and pei.information_type = 'GHR_US_PER_SERVICE_OBLIGATION'
771: order by pei.person_extra_info_id;
772:

Line 780: l_PEOPEI_DATA PER_PEOPLE_EXTRA_INFO%ROWTYPE;

776: where user_table_id = p_user_table_id;
777:
778:
779: l_proc varchar2(30) := 'get_from_history_peopei';
780: l_PEOPEI_DATA PER_PEOPLE_EXTRA_INFO%ROWTYPE;
781: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;
782: l_type_of_employment per_people_extra_info.pei_information4%TYPE;
783: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
784: l_session ghr_history_api.g_session_var_type;

Line 781: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;

777:
778:
779: l_proc varchar2(30) := 'get_from_history_peopei';
780: l_PEOPEI_DATA PER_PEOPLE_EXTRA_INFO%ROWTYPE;
781: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;
782: l_type_of_employment per_people_extra_info.pei_information4%TYPE;
783: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
784: l_session ghr_history_api.g_session_var_type;
785: l_extra_info_id per_people_extra_info.person_extra_info_id%type;

Line 782: l_type_of_employment per_people_extra_info.pei_information4%TYPE;

778:
779: l_proc varchar2(30) := 'get_from_history_peopei';
780: l_PEOPEI_DATA PER_PEOPLE_EXTRA_INFO%ROWTYPE;
781: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;
782: l_type_of_employment per_people_extra_info.pei_information4%TYPE;
783: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
784: l_session ghr_history_api.g_session_var_type;
785: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
786: l_result varchar2(20);

Line 785: l_extra_info_id per_people_extra_info.person_extra_info_id%type;

781: l_PEOPEI_DATA_INIT PER_PEOPLE_EXTRA_INFO%ROWTYPE;
782: l_type_of_employment per_people_extra_info.pei_information4%TYPE;
783: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
784: l_session ghr_history_api.g_session_var_type;
785: l_extra_info_id per_people_extra_info.person_extra_info_id%type;
786: l_result varchar2(20);
787: l_cnt number;
788: l_user_table_id number;
789: l_message_name varchar2(50);