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

Line 49: FROM per_people_extra_info pei

45: ,pei.pei_information6 retained_user_table_id
46: ---- ,pei.pei_information7 retained_locality_percent
47: ,pei.pei_information8 retained_pay_basis
48: ,pei.pei_information9 retained_temp_step
49: FROM per_people_extra_info pei
50: WHERE pei.person_id = p_person_id
51: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
52: AND p_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1),p_effective_date)
53: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)

Line 56: FROM per_people_extra_info pei2

52: AND p_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1),p_effective_date)
53: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date)
54: AND fnd_date.canonical_to_date(pei.pei_information1) =
55: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )
56: FROM per_people_extra_info pei2
57: WHERE pei2.person_id = p_person_id
58: AND pei2.information_type = 'GHR_US_RETAINED_GRADE'
59: AND p_effective_date
60: BETWEEN NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date)

Line 224: FROM per_people_extra_info pei

220: ,pei.pei_information6 retained_user_table_id
221: ---- ,pei.pei_information7 retained_locality_percent
222: ,pei.pei_information8 retained_pay_basis
223: ,pei.pei_information9 retained_temp_step
224: FROM per_people_extra_info pei
225: WHERE pei.person_id = p_person_id
226: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
227: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date) < p_effective_date
228: AND fnd_date.canonical_to_date(pei.pei_information1) =

Line 230: FROM per_people_extra_info pei2

226: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
227: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date) < p_effective_date
228: AND fnd_date.canonical_to_date(pei.pei_information1) =
229: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )
230: FROM per_people_extra_info pei2
231: WHERE pei2.person_id = p_person_id
232: AND pei2.information_type = 'GHR_US_RETAINED_GRADE'
233: AND NVL(fnd_date.canonical_to_date(pei2.pei_information2),p_effective_date) < p_effective_date
234: AND pei2.person_extra_info_id NOT IN (SELECT rei_information3

Line 1082: l_temp_step per_people_extra_info.pei_information6%type;

1078: l_prd_effective_date date;
1079: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
1080: l_position_id per_assignments_f.position_id%type;
1081: l_assignment_id per_assignments_f.assignment_id%type;
1082: l_temp_step per_people_extra_info.pei_information6%type;
1083: l_effective_date date;
1084:
1085: --Cursor to get the position id.
1086: CURSOR cur_per_pos(p_effective_date date) is

Line 1109: FROM per_people_extra_info pei

1105: CURSOR cur_pei (p_effective_date date) IS
1106: SELECT pei.person_extra_info_id
1107: ,pei.pei_information6 retained_user_table_id
1108: ,pei.pei_information9 retained_temp_step
1109: FROM per_people_extra_info pei
1110: WHERE pei.person_id = p_pay_calc_data.person_id
1111: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
1112: AND p_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1),p_effective_date)
1113: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date);