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 241: FROM per_people_extra_info pei

237: ,pei.pei_information6 retained_user_table_id
238: ---- ,pei.pei_information7 retained_locality_percent
239: ,pei.pei_information8 retained_pay_basis
240: ,pei.pei_information9 retained_temp_step
241: FROM per_people_extra_info pei
242: WHERE pei.person_id = p_person_id
243: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
244: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date) < p_effective_date
245: AND fnd_date.canonical_to_date(pei.pei_information1) =

Line 247: FROM per_people_extra_info pei2

243: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
244: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date) < p_effective_date
245: AND fnd_date.canonical_to_date(pei.pei_information1) =
246: (SELECT MIN (NVL(fnd_date.canonical_to_date(pei2.pei_information1),p_effective_date) )
247: FROM per_people_extra_info pei2
248: WHERE pei2.person_id = p_person_id
249: AND pei2.information_type = 'GHR_US_RETAINED_GRADE'
250: AND NVL(fnd_date.canonical_to_date(pei2.pei_information2),p_effective_date) < p_effective_date
251: AND pei2.person_extra_info_id NOT IN (SELECT rei_information3

Line 1099: l_temp_step per_people_extra_info.pei_information6%type;

1095: l_prd_effective_date date;
1096: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
1097: l_position_id per_assignments_f.position_id%type;
1098: l_assignment_id per_assignments_f.assignment_id%type;
1099: l_temp_step per_people_extra_info.pei_information6%type;
1100: l_effective_date date;
1101:
1102: --Cursor to get the position id.
1103: CURSOR cur_per_pos(p_effective_date date) is

Line 1126: FROM per_people_extra_info pei

1122: CURSOR cur_pei (p_effective_date date) IS
1123: SELECT pei.person_extra_info_id
1124: ,pei.pei_information6 retained_user_table_id
1125: ,pei.pei_information9 retained_temp_step
1126: FROM per_people_extra_info pei
1127: WHERE pei.person_id = p_pay_calc_data.person_id
1128: AND pei.information_type = 'GHR_US_RETAINED_GRADE'
1129: AND p_effective_date BETWEEN NVL(fnd_date.canonical_to_date(pei.pei_information1),p_effective_date)
1130: AND NVL(fnd_date.canonical_to_date(pei.pei_information2),p_effective_date);