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_SF52_DO_UPDATE dependencies on PER_PEOPLE_EXTRA_INFO

Line 62: l_per_cre_extra_info_id per_people_extra_info.person_extra_info_id%type;

58: l_extra_info_rec ghr_api.extra_info_rec_type;
59: --
60: l_asg_cre_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
61: l_asg_cre_ovn per_assignment_extra_info.object_version_number%type;
62: l_per_cre_extra_info_id per_people_extra_info.person_extra_info_id%type;
63: l_per_cre_ovn per_people_extra_info.object_version_number%type;
64: l_pos1_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
65: l_pos1_cre_ovn per_position_extra_info.object_version_number%type;
66: --

Line 63: l_per_cre_ovn per_people_extra_info.object_version_number%type;

59: --
60: l_asg_cre_extra_info_id per_assignment_extra_info.assignment_extra_info_id%type;
61: l_asg_cre_ovn per_assignment_extra_info.object_version_number%type;
62: l_per_cre_extra_info_id per_people_extra_info.person_extra_info_id%type;
63: l_per_cre_ovn per_people_extra_info.object_version_number%type;
64: l_pos1_cre_extra_info_id per_position_extra_info.position_extra_info_id%type;
65: l_pos1_cre_ovn per_position_extra_info.object_version_number%type;
66: --
67: l_information1 varchar2(150);

Line 112: from per_people_extra_info

108:
109: Cursor c_per_ei is
110: select person_extra_info_id,
111: object_version_number
112: from per_people_extra_info
113: where person_id = l_id
114: and information_type = p_l_information_type;
115:
116: Cursor c_pos_ei is

Line 631: per_people_extra_info pei

627: cursor c_702_rec is
628: select rei_information3,pei_information1,
629: pei.object_version_number ovn
630: from ghr_pa_request_extra_info rei,
631: per_people_extra_info pei
632: where pa_request_id = p_pa_request_rec.pa_request_id
633: and pei.person_extra_info_id = rei.rei_information3
634: and pei.information_type = 'GHR_US_RETAINED_GRADE'
635: and rei.information_type = 'GHR_US_PAR_TERM_RG_PROMO'

Line 642: per_people_extra_info pei

638: cursor c_740_rec is
639: select rei_information3,pei_information1,
640: pei.object_version_number ovn
641: from ghr_pa_request_extra_info rei,
642: per_people_extra_info pei
643: where pa_request_id = p_pa_request_rec.pa_request_id
644: and pei.person_extra_info_id = rei.rei_information3
645: and pei.information_type = 'GHR_US_RETAINED_GRADE'
646: and rei.information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'

Line 654: l_cur_date_from per_people_extra_info.pei_information1%type;

650:
651: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
652: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
653: -- Bug#4698321 created l_cur_date_from variable.
654: l_cur_date_from per_people_extra_info.pei_information1%type;
655: l_new_date_to per_people_extra_info.pei_information1%type;
656: l_new_grade_or_level per_people_extra_info.pei_information3%type;
657: l_new_pay_plan per_people_extra_info.pei_information3%type;
658: l_new_pay_table per_people_extra_info.pei_information3%type;

Line 655: l_new_date_to per_people_extra_info.pei_information1%type;

651: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
652: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
653: -- Bug#4698321 created l_cur_date_from variable.
654: l_cur_date_from per_people_extra_info.pei_information1%type;
655: l_new_date_to per_people_extra_info.pei_information1%type;
656: l_new_grade_or_level per_people_extra_info.pei_information3%type;
657: l_new_pay_plan per_people_extra_info.pei_information3%type;
658: l_new_pay_table per_people_extra_info.pei_information3%type;
659: l_new_loc_percent per_people_extra_info.pei_information3%type;

Line 656: l_new_grade_or_level per_people_extra_info.pei_information3%type;

652: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
653: -- Bug#4698321 created l_cur_date_from variable.
654: l_cur_date_from per_people_extra_info.pei_information1%type;
655: l_new_date_to per_people_extra_info.pei_information1%type;
656: l_new_grade_or_level per_people_extra_info.pei_information3%type;
657: l_new_pay_plan per_people_extra_info.pei_information3%type;
658: l_new_pay_table per_people_extra_info.pei_information3%type;
659: l_new_loc_percent per_people_extra_info.pei_information3%type;
660: l_new_pay_basis per_people_extra_info.pei_information3%type;

Line 657: l_new_pay_plan per_people_extra_info.pei_information3%type;

653: -- Bug#4698321 created l_cur_date_from variable.
654: l_cur_date_from per_people_extra_info.pei_information1%type;
655: l_new_date_to per_people_extra_info.pei_information1%type;
656: l_new_grade_or_level per_people_extra_info.pei_information3%type;
657: l_new_pay_plan per_people_extra_info.pei_information3%type;
658: l_new_pay_table per_people_extra_info.pei_information3%type;
659: l_new_loc_percent per_people_extra_info.pei_information3%type;
660: l_new_pay_basis per_people_extra_info.pei_information3%type;
661: l_temp_step per_people_extra_info.pei_information9%type;

Line 658: l_new_pay_table per_people_extra_info.pei_information3%type;

654: l_cur_date_from per_people_extra_info.pei_information1%type;
655: l_new_date_to per_people_extra_info.pei_information1%type;
656: l_new_grade_or_level per_people_extra_info.pei_information3%type;
657: l_new_pay_plan per_people_extra_info.pei_information3%type;
658: l_new_pay_table per_people_extra_info.pei_information3%type;
659: l_new_loc_percent per_people_extra_info.pei_information3%type;
660: l_new_pay_basis per_people_extra_info.pei_information3%type;
661: l_temp_step per_people_extra_info.pei_information9%type;
662: l_new_temp_step per_people_extra_info.pei_information9%type;

Line 659: l_new_loc_percent per_people_extra_info.pei_information3%type;

655: l_new_date_to per_people_extra_info.pei_information1%type;
656: l_new_grade_or_level per_people_extra_info.pei_information3%type;
657: l_new_pay_plan per_people_extra_info.pei_information3%type;
658: l_new_pay_table per_people_extra_info.pei_information3%type;
659: l_new_loc_percent per_people_extra_info.pei_information3%type;
660: l_new_pay_basis per_people_extra_info.pei_information3%type;
661: l_temp_step per_people_extra_info.pei_information9%type;
662: l_new_temp_step per_people_extra_info.pei_information9%type;
663: l_new_step_or_rate per_people_extra_info.pei_information4%type;

Line 660: l_new_pay_basis per_people_extra_info.pei_information3%type;

656: l_new_grade_or_level per_people_extra_info.pei_information3%type;
657: l_new_pay_plan per_people_extra_info.pei_information3%type;
658: l_new_pay_table per_people_extra_info.pei_information3%type;
659: l_new_loc_percent per_people_extra_info.pei_information3%type;
660: l_new_pay_basis per_people_extra_info.pei_information3%type;
661: l_temp_step per_people_extra_info.pei_information9%type;
662: l_new_temp_step per_people_extra_info.pei_information9%type;
663: l_new_step_or_rate per_people_extra_info.pei_information4%type;
664: l_step_or_rate per_people_extra_info.pei_information4%type;

Line 661: l_temp_step per_people_extra_info.pei_information9%type;

657: l_new_pay_plan per_people_extra_info.pei_information3%type;
658: l_new_pay_table per_people_extra_info.pei_information3%type;
659: l_new_loc_percent per_people_extra_info.pei_information3%type;
660: l_new_pay_basis per_people_extra_info.pei_information3%type;
661: l_temp_step per_people_extra_info.pei_information9%type;
662: l_new_temp_step per_people_extra_info.pei_information9%type;
663: l_new_step_or_rate per_people_extra_info.pei_information4%type;
664: l_step_or_rate per_people_extra_info.pei_information4%type;
665: l_ret_object_version_number ghr_pa_requests.object_version_number%type;

Line 662: l_new_temp_step per_people_extra_info.pei_information9%type;

658: l_new_pay_table per_people_extra_info.pei_information3%type;
659: l_new_loc_percent per_people_extra_info.pei_information3%type;
660: l_new_pay_basis per_people_extra_info.pei_information3%type;
661: l_temp_step per_people_extra_info.pei_information9%type;
662: l_new_temp_step per_people_extra_info.pei_information9%type;
663: l_new_step_or_rate per_people_extra_info.pei_information4%type;
664: l_step_or_rate per_people_extra_info.pei_information4%type;
665: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
666: l_ovn ghr_pa_requests.object_version_number%type;

Line 663: l_new_step_or_rate per_people_extra_info.pei_information4%type;

659: l_new_loc_percent per_people_extra_info.pei_information3%type;
660: l_new_pay_basis per_people_extra_info.pei_information3%type;
661: l_temp_step per_people_extra_info.pei_information9%type;
662: l_new_temp_step per_people_extra_info.pei_information9%type;
663: l_new_step_or_rate per_people_extra_info.pei_information4%type;
664: l_step_or_rate per_people_extra_info.pei_information4%type;
665: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
666: l_ovn ghr_pa_requests.object_version_number%type;
667:

Line 664: l_step_or_rate per_people_extra_info.pei_information4%type;

660: l_new_pay_basis per_people_extra_info.pei_information3%type;
661: l_temp_step per_people_extra_info.pei_information9%type;
662: l_new_temp_step per_people_extra_info.pei_information9%type;
663: l_new_step_or_rate per_people_extra_info.pei_information4%type;
664: l_step_or_rate per_people_extra_info.pei_information4%type;
665: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
666: l_ovn ghr_pa_requests.object_version_number%type;
667:
668:

Line 691: from per_people_extra_info

687: pei_information6,
688: pei_information7,
689: pei_information8,
690: pei_information9
691: from per_people_extra_info
692: where person_extra_info_id = l_retained_grade_rec.person_extra_info_id;
693:
694: l_effective_date Date;
695: BEGIN

Line 1453: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;

1449: l_first_noa_code ghr_pa_requests.first_noa_code%type;
1450: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1451: l_fam_code ghr_pa_requests.noa_family_code%type;
1452:
1453: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
1454: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
1455: --Bug# 4941984(AFHR2)
1456: l_Cur_Appt_Auth_desc1 per_people_extra_info.pei_information22%type;
1457: l_Cur_Appt_Auth_desc2 per_people_extra_info.pei_information23%type;

Line 1454: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;

1450: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1451: l_fam_code ghr_pa_requests.noa_family_code%type;
1452:
1453: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
1454: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
1455: --Bug# 4941984(AFHR2)
1456: l_Cur_Appt_Auth_desc1 per_people_extra_info.pei_information22%type;
1457: l_Cur_Appt_Auth_desc2 per_people_extra_info.pei_information23%type;
1458: --Bug# 4941984(AFHR2)

Line 1456: l_Cur_Appt_Auth_desc1 per_people_extra_info.pei_information22%type;

1452:
1453: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
1454: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
1455: --Bug# 4941984(AFHR2)
1456: l_Cur_Appt_Auth_desc1 per_people_extra_info.pei_information22%type;
1457: l_Cur_Appt_Auth_desc2 per_people_extra_info.pei_information23%type;
1458: --Bug# 4941984(AFHR2)
1459:
1460: -- No copy Changes variables.

Line 1457: l_Cur_Appt_Auth_desc2 per_people_extra_info.pei_information23%type;

1453: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
1454: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
1455: --Bug# 4941984(AFHR2)
1456: l_Cur_Appt_Auth_desc1 per_people_extra_info.pei_information22%type;
1457: l_Cur_Appt_Auth_desc2 per_people_extra_info.pei_information23%type;
1458: --Bug# 4941984(AFHR2)
1459:
1460: -- No copy Changes variables.
1461: l_Asg_Sf52 GHR_API.Asg_Sf52_TYPE;

Line 4764: l_new_date_to per_people_extra_info.pei_information1%type;

4760: v_asg_effective_start_date date;
4761: v_asg_effective_end_date date;
4762: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
4763: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
4764: l_new_date_to per_people_extra_info.pei_information1%type;
4765: l_new_grade_or_level per_people_extra_info.pei_information3%type;
4766: l_new_pay_plan per_people_extra_info.pei_information3%type;
4767: l_new_pay_table per_people_extra_info.pei_information3%type;
4768: l_new_loc_percent per_people_extra_info.pei_information3%type;

Line 4765: l_new_grade_or_level per_people_extra_info.pei_information3%type;

4761: v_asg_effective_end_date date;
4762: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
4763: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
4764: l_new_date_to per_people_extra_info.pei_information1%type;
4765: l_new_grade_or_level per_people_extra_info.pei_information3%type;
4766: l_new_pay_plan per_people_extra_info.pei_information3%type;
4767: l_new_pay_table per_people_extra_info.pei_information3%type;
4768: l_new_loc_percent per_people_extra_info.pei_information3%type;
4769: l_new_pay_basis per_people_extra_info.pei_information3%type;

Line 4766: l_new_pay_plan per_people_extra_info.pei_information3%type;

4762: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
4763: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
4764: l_new_date_to per_people_extra_info.pei_information1%type;
4765: l_new_grade_or_level per_people_extra_info.pei_information3%type;
4766: l_new_pay_plan per_people_extra_info.pei_information3%type;
4767: l_new_pay_table per_people_extra_info.pei_information3%type;
4768: l_new_loc_percent per_people_extra_info.pei_information3%type;
4769: l_new_pay_basis per_people_extra_info.pei_information3%type;
4770: l_new_step_or_rate per_people_extra_info.pei_information4%type;

Line 4767: l_new_pay_table per_people_extra_info.pei_information3%type;

4763: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
4764: l_new_date_to per_people_extra_info.pei_information1%type;
4765: l_new_grade_or_level per_people_extra_info.pei_information3%type;
4766: l_new_pay_plan per_people_extra_info.pei_information3%type;
4767: l_new_pay_table per_people_extra_info.pei_information3%type;
4768: l_new_loc_percent per_people_extra_info.pei_information3%type;
4769: l_new_pay_basis per_people_extra_info.pei_information3%type;
4770: l_new_step_or_rate per_people_extra_info.pei_information4%type;
4771: l_cur_step_or_rate per_people_extra_info.pei_information4%type;

Line 4768: l_new_loc_percent per_people_extra_info.pei_information3%type;

4764: l_new_date_to per_people_extra_info.pei_information1%type;
4765: l_new_grade_or_level per_people_extra_info.pei_information3%type;
4766: l_new_pay_plan per_people_extra_info.pei_information3%type;
4767: l_new_pay_table per_people_extra_info.pei_information3%type;
4768: l_new_loc_percent per_people_extra_info.pei_information3%type;
4769: l_new_pay_basis per_people_extra_info.pei_information3%type;
4770: l_new_step_or_rate per_people_extra_info.pei_information4%type;
4771: l_cur_step_or_rate per_people_extra_info.pei_information4%type;
4772: l_new_temp_step per_people_extra_info.pei_information9%type;

Line 4769: l_new_pay_basis per_people_extra_info.pei_information3%type;

4765: l_new_grade_or_level per_people_extra_info.pei_information3%type;
4766: l_new_pay_plan per_people_extra_info.pei_information3%type;
4767: l_new_pay_table per_people_extra_info.pei_information3%type;
4768: l_new_loc_percent per_people_extra_info.pei_information3%type;
4769: l_new_pay_basis per_people_extra_info.pei_information3%type;
4770: l_new_step_or_rate per_people_extra_info.pei_information4%type;
4771: l_cur_step_or_rate per_people_extra_info.pei_information4%type;
4772: l_new_temp_step per_people_extra_info.pei_information9%type;
4773: l_ret_object_version_number ghr_pa_requests.object_version_number%type;

Line 4770: l_new_step_or_rate per_people_extra_info.pei_information4%type;

4766: l_new_pay_plan per_people_extra_info.pei_information3%type;
4767: l_new_pay_table per_people_extra_info.pei_information3%type;
4768: l_new_loc_percent per_people_extra_info.pei_information3%type;
4769: l_new_pay_basis per_people_extra_info.pei_information3%type;
4770: l_new_step_or_rate per_people_extra_info.pei_information4%type;
4771: l_cur_step_or_rate per_people_extra_info.pei_information4%type;
4772: l_new_temp_step per_people_extra_info.pei_information9%type;
4773: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
4774: l_effective_date date;

Line 4771: l_cur_step_or_rate per_people_extra_info.pei_information4%type;

4767: l_new_pay_table per_people_extra_info.pei_information3%type;
4768: l_new_loc_percent per_people_extra_info.pei_information3%type;
4769: l_new_pay_basis per_people_extra_info.pei_information3%type;
4770: l_new_step_or_rate per_people_extra_info.pei_information4%type;
4771: l_cur_step_or_rate per_people_extra_info.pei_information4%type;
4772: l_new_temp_step per_people_extra_info.pei_information9%type;
4773: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
4774: l_effective_date date;
4775: l_session ghr_history_api.g_session_var_type;

Line 4772: l_new_temp_step per_people_extra_info.pei_information9%type;

4768: l_new_loc_percent per_people_extra_info.pei_information3%type;
4769: l_new_pay_basis per_people_extra_info.pei_information3%type;
4770: l_new_step_or_rate per_people_extra_info.pei_information4%type;
4771: l_cur_step_or_rate per_people_extra_info.pei_information4%type;
4772: l_new_temp_step per_people_extra_info.pei_information9%type;
4773: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
4774: l_effective_date date;
4775: l_session ghr_history_api.g_session_var_type;
4776: l_value varchar2(30);

Line 4823: from per_people_extra_info

4819: pei_information6,
4820: pei_information7,
4821: pei_information8,
4822: pei_information9
4823: from per_people_extra_info
4824: where person_extra_info_id = l_retained_grade_rec.person_extra_info_id;
4825:
4826: l_wgi ghr_api.within_grade_increase_type;
4827: l_retention_allow_review ghr_api.retention_allow_review_type;