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 115: from per_people_extra_info

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

Line 646: per_people_extra_info pei

642: cursor c_702_rec is
643: select rei_information3,pei_information1,
644: pei.object_version_number ovn
645: from ghr_pa_request_extra_info rei,
646: per_people_extra_info pei
647: where pa_request_id = p_pa_request_rec.pa_request_id
648: and pei.person_extra_info_id = rei.rei_information3
649: and pei.information_type = 'GHR_US_RETAINED_GRADE'
650: and rei.information_type = 'GHR_US_PAR_TERM_RG_PROMO'

Line 657: per_people_extra_info pei

653: cursor c_740_rec is
654: select rei_information3,pei_information1,
655: pei.object_version_number ovn
656: from ghr_pa_request_extra_info rei,
657: per_people_extra_info pei
658: where pa_request_id = p_pa_request_rec.pa_request_id
659: and pei.person_extra_info_id = rei.rei_information3
660: and pei.information_type = 'GHR_US_RETAINED_GRADE'
661: and rei.information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'

Line 669: l_cur_date_from per_people_extra_info.pei_information1%type;

665:
666: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
667: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
668: -- Bug#4698321 created l_cur_date_from variable.
669: l_cur_date_from per_people_extra_info.pei_information1%type;
670: l_new_date_to per_people_extra_info.pei_information1%type;
671: l_new_grade_or_level per_people_extra_info.pei_information3%type;
672: l_new_pay_plan per_people_extra_info.pei_information3%type;
673: l_new_pay_table per_people_extra_info.pei_information3%type;

Line 670: l_new_date_to per_people_extra_info.pei_information1%type;

666: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
667: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
668: -- Bug#4698321 created l_cur_date_from variable.
669: l_cur_date_from per_people_extra_info.pei_information1%type;
670: l_new_date_to per_people_extra_info.pei_information1%type;
671: l_new_grade_or_level per_people_extra_info.pei_information3%type;
672: l_new_pay_plan per_people_extra_info.pei_information3%type;
673: l_new_pay_table per_people_extra_info.pei_information3%type;
674: l_new_loc_percent per_people_extra_info.pei_information3%type;

Line 671: l_new_grade_or_level per_people_extra_info.pei_information3%type;

667: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
668: -- Bug#4698321 created l_cur_date_from variable.
669: l_cur_date_from per_people_extra_info.pei_information1%type;
670: l_new_date_to per_people_extra_info.pei_information1%type;
671: l_new_grade_or_level per_people_extra_info.pei_information3%type;
672: l_new_pay_plan per_people_extra_info.pei_information3%type;
673: l_new_pay_table per_people_extra_info.pei_information3%type;
674: l_new_loc_percent per_people_extra_info.pei_information3%type;
675: l_new_pay_basis per_people_extra_info.pei_information3%type;

Line 672: l_new_pay_plan per_people_extra_info.pei_information3%type;

668: -- Bug#4698321 created l_cur_date_from variable.
669: l_cur_date_from per_people_extra_info.pei_information1%type;
670: l_new_date_to per_people_extra_info.pei_information1%type;
671: l_new_grade_or_level per_people_extra_info.pei_information3%type;
672: l_new_pay_plan per_people_extra_info.pei_information3%type;
673: l_new_pay_table per_people_extra_info.pei_information3%type;
674: l_new_loc_percent per_people_extra_info.pei_information3%type;
675: l_new_pay_basis per_people_extra_info.pei_information3%type;
676: l_temp_step per_people_extra_info.pei_information9%type;

Line 673: l_new_pay_table per_people_extra_info.pei_information3%type;

669: l_cur_date_from per_people_extra_info.pei_information1%type;
670: l_new_date_to per_people_extra_info.pei_information1%type;
671: l_new_grade_or_level per_people_extra_info.pei_information3%type;
672: l_new_pay_plan per_people_extra_info.pei_information3%type;
673: l_new_pay_table per_people_extra_info.pei_information3%type;
674: l_new_loc_percent per_people_extra_info.pei_information3%type;
675: l_new_pay_basis per_people_extra_info.pei_information3%type;
676: l_temp_step per_people_extra_info.pei_information9%type;
677: l_new_temp_step per_people_extra_info.pei_information9%type;

Line 674: l_new_loc_percent per_people_extra_info.pei_information3%type;

670: l_new_date_to per_people_extra_info.pei_information1%type;
671: l_new_grade_or_level per_people_extra_info.pei_information3%type;
672: l_new_pay_plan per_people_extra_info.pei_information3%type;
673: l_new_pay_table per_people_extra_info.pei_information3%type;
674: l_new_loc_percent per_people_extra_info.pei_information3%type;
675: l_new_pay_basis per_people_extra_info.pei_information3%type;
676: l_temp_step per_people_extra_info.pei_information9%type;
677: l_new_temp_step per_people_extra_info.pei_information9%type;
678: l_new_step_or_rate per_people_extra_info.pei_information4%type;

Line 675: l_new_pay_basis per_people_extra_info.pei_information3%type;

671: l_new_grade_or_level per_people_extra_info.pei_information3%type;
672: l_new_pay_plan per_people_extra_info.pei_information3%type;
673: l_new_pay_table per_people_extra_info.pei_information3%type;
674: l_new_loc_percent per_people_extra_info.pei_information3%type;
675: l_new_pay_basis per_people_extra_info.pei_information3%type;
676: l_temp_step per_people_extra_info.pei_information9%type;
677: l_new_temp_step per_people_extra_info.pei_information9%type;
678: l_new_step_or_rate per_people_extra_info.pei_information4%type;
679: l_step_or_rate per_people_extra_info.pei_information4%type;

Line 676: l_temp_step per_people_extra_info.pei_information9%type;

672: l_new_pay_plan per_people_extra_info.pei_information3%type;
673: l_new_pay_table per_people_extra_info.pei_information3%type;
674: l_new_loc_percent per_people_extra_info.pei_information3%type;
675: l_new_pay_basis per_people_extra_info.pei_information3%type;
676: l_temp_step per_people_extra_info.pei_information9%type;
677: l_new_temp_step per_people_extra_info.pei_information9%type;
678: l_new_step_or_rate per_people_extra_info.pei_information4%type;
679: l_step_or_rate per_people_extra_info.pei_information4%type;
680: l_ret_object_version_number ghr_pa_requests.object_version_number%type;

Line 677: l_new_temp_step per_people_extra_info.pei_information9%type;

673: l_new_pay_table per_people_extra_info.pei_information3%type;
674: l_new_loc_percent per_people_extra_info.pei_information3%type;
675: l_new_pay_basis per_people_extra_info.pei_information3%type;
676: l_temp_step per_people_extra_info.pei_information9%type;
677: l_new_temp_step per_people_extra_info.pei_information9%type;
678: l_new_step_or_rate per_people_extra_info.pei_information4%type;
679: l_step_or_rate per_people_extra_info.pei_information4%type;
680: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
681: l_ovn ghr_pa_requests.object_version_number%type;

Line 678: l_new_step_or_rate per_people_extra_info.pei_information4%type;

674: l_new_loc_percent per_people_extra_info.pei_information3%type;
675: l_new_pay_basis per_people_extra_info.pei_information3%type;
676: l_temp_step per_people_extra_info.pei_information9%type;
677: l_new_temp_step per_people_extra_info.pei_information9%type;
678: l_new_step_or_rate per_people_extra_info.pei_information4%type;
679: l_step_or_rate per_people_extra_info.pei_information4%type;
680: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
681: l_ovn ghr_pa_requests.object_version_number%type;
682:

Line 679: l_step_or_rate per_people_extra_info.pei_information4%type;

675: l_new_pay_basis per_people_extra_info.pei_information3%type;
676: l_temp_step per_people_extra_info.pei_information9%type;
677: l_new_temp_step per_people_extra_info.pei_information9%type;
678: l_new_step_or_rate per_people_extra_info.pei_information4%type;
679: l_step_or_rate per_people_extra_info.pei_information4%type;
680: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
681: l_ovn ghr_pa_requests.object_version_number%type;
682:
683:

Line 706: from per_people_extra_info

702: pei_information6,
703: pei_information7,
704: pei_information8,
705: pei_information9
706: from per_people_extra_info
707: where person_extra_info_id = l_retained_grade_rec.person_extra_info_id;
708:
709: l_effective_date Date;
710: BEGIN

Line 1469: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;

1465: l_first_noa_code ghr_pa_requests.first_noa_code%type;
1466: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1467: l_fam_code ghr_pa_requests.noa_family_code%type;
1468:
1469: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
1470: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
1471: --Bug# 4941984(AFHR2)
1472: l_Cur_Appt_Auth_desc1 per_people_extra_info.pei_information22%type;
1473: l_Cur_Appt_Auth_desc2 per_people_extra_info.pei_information23%type;

Line 1470: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;

1466: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1467: l_fam_code ghr_pa_requests.noa_family_code%type;
1468:
1469: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
1470: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
1471: --Bug# 4941984(AFHR2)
1472: l_Cur_Appt_Auth_desc1 per_people_extra_info.pei_information22%type;
1473: l_Cur_Appt_Auth_desc2 per_people_extra_info.pei_information23%type;
1474: --Bug# 4941984(AFHR2)

Line 1472: l_Cur_Appt_Auth_desc1 per_people_extra_info.pei_information22%type;

1468:
1469: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
1470: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
1471: --Bug# 4941984(AFHR2)
1472: l_Cur_Appt_Auth_desc1 per_people_extra_info.pei_information22%type;
1473: l_Cur_Appt_Auth_desc2 per_people_extra_info.pei_information23%type;
1474: --Bug# 4941984(AFHR2)
1475: --Begin Bug# 12557463, commented below cursor
1476: --bug# 12596901,12994100

Line 1473: l_Cur_Appt_Auth_desc2 per_people_extra_info.pei_information23%type;

1469: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
1470: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
1471: --Bug# 4941984(AFHR2)
1472: l_Cur_Appt_Auth_desc1 per_people_extra_info.pei_information22%type;
1473: l_Cur_Appt_Auth_desc2 per_people_extra_info.pei_information23%type;
1474: --Bug# 4941984(AFHR2)
1475: --Begin Bug# 12557463, commented below cursor
1476: --bug# 12596901,12994100
1477: /*l_scd_tsp per_people_extra_info.pei_information6%type;

Line 1477: /*l_scd_tsp per_people_extra_info.pei_information6%type;

1473: l_Cur_Appt_Auth_desc2 per_people_extra_info.pei_information23%type;
1474: --Bug# 4941984(AFHR2)
1475: --Begin Bug# 12557463, commented below cursor
1476: --bug# 12596901,12994100
1477: /*l_scd_tsp per_people_extra_info.pei_information6%type;
1478: cursor c_scd_tsp(c_person_id ghr_pa_requests.person_id%type,eff_date ghr_pa_requests.effective_date%type) is
1479: select information12
1480: from ghr_pa_history
1481: where person_id = c_person_id

Line 1483: and table_name = 'PER_PEOPLE_EXTRA_INFO'

1479: select information12
1480: from ghr_pa_history
1481: where person_id = c_person_id
1482: and information5 = 'GHR_US_PER_SCD_INFORMATION'
1483: and table_name = 'PER_PEOPLE_EXTRA_INFO'
1484: and effective_date = eff_date
1485: order by pa_history_id desc;
1486: */
1487: --bug# 12596901,12994100

Line 5023: l_new_date_to per_people_extra_info.pei_information1%type;

5019: v_asg_effective_start_date date;
5020: v_asg_effective_end_date date;
5021: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
5022: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
5023: l_new_date_to per_people_extra_info.pei_information1%type;
5024: l_new_grade_or_level per_people_extra_info.pei_information3%type;
5025: l_new_pay_plan per_people_extra_info.pei_information3%type;
5026: l_new_pay_table per_people_extra_info.pei_information3%type;
5027: l_new_loc_percent per_people_extra_info.pei_information3%type;

Line 5024: l_new_grade_or_level per_people_extra_info.pei_information3%type;

5020: v_asg_effective_end_date date;
5021: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
5022: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
5023: l_new_date_to per_people_extra_info.pei_information1%type;
5024: l_new_grade_or_level per_people_extra_info.pei_information3%type;
5025: l_new_pay_plan per_people_extra_info.pei_information3%type;
5026: l_new_pay_table per_people_extra_info.pei_information3%type;
5027: l_new_loc_percent per_people_extra_info.pei_information3%type;
5028: l_new_pay_basis per_people_extra_info.pei_information3%type;

Line 5025: l_new_pay_plan per_people_extra_info.pei_information3%type;

5021: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
5022: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
5023: l_new_date_to per_people_extra_info.pei_information1%type;
5024: l_new_grade_or_level per_people_extra_info.pei_information3%type;
5025: l_new_pay_plan per_people_extra_info.pei_information3%type;
5026: l_new_pay_table per_people_extra_info.pei_information3%type;
5027: l_new_loc_percent per_people_extra_info.pei_information3%type;
5028: l_new_pay_basis per_people_extra_info.pei_information3%type;
5029: l_new_step_or_rate per_people_extra_info.pei_information4%type;

Line 5026: l_new_pay_table per_people_extra_info.pei_information3%type;

5022: l_ret_grade_rec ghr_pay_calc.retained_grade_rec_type;
5023: l_new_date_to per_people_extra_info.pei_information1%type;
5024: l_new_grade_or_level per_people_extra_info.pei_information3%type;
5025: l_new_pay_plan per_people_extra_info.pei_information3%type;
5026: l_new_pay_table per_people_extra_info.pei_information3%type;
5027: l_new_loc_percent per_people_extra_info.pei_information3%type;
5028: l_new_pay_basis per_people_extra_info.pei_information3%type;
5029: l_new_step_or_rate per_people_extra_info.pei_information4%type;
5030: l_cur_step_or_rate per_people_extra_info.pei_information4%type;

Line 5027: l_new_loc_percent per_people_extra_info.pei_information3%type;

5023: l_new_date_to per_people_extra_info.pei_information1%type;
5024: l_new_grade_or_level per_people_extra_info.pei_information3%type;
5025: l_new_pay_plan per_people_extra_info.pei_information3%type;
5026: l_new_pay_table per_people_extra_info.pei_information3%type;
5027: l_new_loc_percent per_people_extra_info.pei_information3%type;
5028: l_new_pay_basis per_people_extra_info.pei_information3%type;
5029: l_new_step_or_rate per_people_extra_info.pei_information4%type;
5030: l_cur_step_or_rate per_people_extra_info.pei_information4%type;
5031: l_new_temp_step per_people_extra_info.pei_information9%type;

Line 5028: l_new_pay_basis per_people_extra_info.pei_information3%type;

5024: l_new_grade_or_level per_people_extra_info.pei_information3%type;
5025: l_new_pay_plan per_people_extra_info.pei_information3%type;
5026: l_new_pay_table per_people_extra_info.pei_information3%type;
5027: l_new_loc_percent per_people_extra_info.pei_information3%type;
5028: l_new_pay_basis per_people_extra_info.pei_information3%type;
5029: l_new_step_or_rate per_people_extra_info.pei_information4%type;
5030: l_cur_step_or_rate per_people_extra_info.pei_information4%type;
5031: l_new_temp_step per_people_extra_info.pei_information9%type;
5032: l_ret_object_version_number ghr_pa_requests.object_version_number%type;

Line 5029: l_new_step_or_rate per_people_extra_info.pei_information4%type;

5025: l_new_pay_plan per_people_extra_info.pei_information3%type;
5026: l_new_pay_table per_people_extra_info.pei_information3%type;
5027: l_new_loc_percent per_people_extra_info.pei_information3%type;
5028: l_new_pay_basis per_people_extra_info.pei_information3%type;
5029: l_new_step_or_rate per_people_extra_info.pei_information4%type;
5030: l_cur_step_or_rate per_people_extra_info.pei_information4%type;
5031: l_new_temp_step per_people_extra_info.pei_information9%type;
5032: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
5033: l_effective_date date;

Line 5030: l_cur_step_or_rate per_people_extra_info.pei_information4%type;

5026: l_new_pay_table per_people_extra_info.pei_information3%type;
5027: l_new_loc_percent per_people_extra_info.pei_information3%type;
5028: l_new_pay_basis per_people_extra_info.pei_information3%type;
5029: l_new_step_or_rate per_people_extra_info.pei_information4%type;
5030: l_cur_step_or_rate per_people_extra_info.pei_information4%type;
5031: l_new_temp_step per_people_extra_info.pei_information9%type;
5032: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
5033: l_effective_date date;
5034: l_session ghr_history_api.g_session_var_type;

Line 5031: l_new_temp_step per_people_extra_info.pei_information9%type;

5027: l_new_loc_percent per_people_extra_info.pei_information3%type;
5028: l_new_pay_basis per_people_extra_info.pei_information3%type;
5029: l_new_step_or_rate per_people_extra_info.pei_information4%type;
5030: l_cur_step_or_rate per_people_extra_info.pei_information4%type;
5031: l_new_temp_step per_people_extra_info.pei_information9%type;
5032: l_ret_object_version_number ghr_pa_requests.object_version_number%type;
5033: l_effective_date date;
5034: l_session ghr_history_api.g_session_var_type;
5035: l_value varchar2(30);

Line 5082: from per_people_extra_info

5078: pei_information6,
5079: pei_information7,
5080: pei_information8,
5081: pei_information9
5082: from per_people_extra_info
5083: where person_extra_info_id = l_retained_grade_rec.person_extra_info_id;
5084:
5085: l_wgi ghr_api.within_grade_increase_type;
5086: l_retention_allow_review ghr_api.retention_allow_review_type;