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.PQH_FR_UTILITY dependencies on PER_PERSON_ANALYSES

Line 139: per_person_analyses ppa

135:
136: Cursor C_national_award_date IS
137: SELECT MAX(fnd_date.canonical_to_date(pea.segment5))
138: FROM per_analysis_criteria pea,
139: per_person_analyses ppa
140: WHERE ppa.person_id = p_person_id
141: AND pea.id_flex_num = l_id_flex_num
142: AND pea.segment1 = p_award_type
143: AND pea.analysis_criteria_id = ppa.analysis_criteria_id;

Line 148: per_person_analyses ppa

144:
145: Cursor C_ministry_award_date IS
146: SELECT MAX(fnd_date.canonical_to_date(pea.segment7))
147: FROM per_analysis_criteria pea,
148: per_person_analyses ppa
149: WHERE ppa.person_id = p_person_id
150: AND pea.id_flex_num = l_id_flex_num
151: AND pea.segment1 = p_award_type
152: AND pea.analysis_criteria_id = ppa.analysis_criteria_id;

Line 161: per_person_analyses ppa

157: -- Selects the most recent award (award type) for a given person, for National award
158: CURSOR C_national_award_type IS
159: SELECT pea.segment1
160: FROM per_analysis_criteria pea,
161: per_person_analyses ppa
162: WHERE ppa.person_id = p_person_id
163: AND pea.id_flex_num = l_id_flex_num
164: AND pea.analysis_criteria_id = ppa.analysis_criteria_id
165: AND pea.segment1 = p_award_type

Line 172: per_person_analyses ppa

168: -- Selects the most recent award (award type) for a given person, for Ministry award
169: CURSOR C_ministry_award_type IS
170: SELECT pea.segment1
171: FROM per_analysis_criteria pea,
172: per_person_analyses ppa
173: WHERE ppa.person_id = p_person_id
174: AND pea.id_flex_num = l_id_flex_num
175: AND pea.analysis_criteria_id = ppa.analysis_criteria_id
176: AND pea.segment1 = p_award_type

Line 228: per_person_analyses ppa

224:
225: Cursor C_national_award_date IS
226: SELECT MAX(fnd_date.canonical_to_date(pea.segment5))
227: FROM per_analysis_criteria pea,
228: per_person_analyses ppa
229: WHERE ppa.person_id = p_person_id
230: AND pea.id_flex_num = l_id_flex_num
231: AND pea.segment1 = p_award_type
232: AND pea.analysis_criteria_id = ppa.analysis_criteria_id;

Line 237: per_person_analyses ppa

233:
234: Cursor C_ministry_award_date IS
235: SELECT MAX(fnd_date.canonical_to_date(pea.segment7))
236: FROM per_analysis_criteria pea,
237: per_person_analyses ppa
238: WHERE ppa.person_id = p_person_id
239: AND pea.id_flex_num = l_id_flex_num
240: AND pea.segment1 = p_award_type
241: AND pea.analysis_criteria_id = ppa.analysis_criteria_id;

Line 250: per_person_analyses ppa

246: -- Selects the most recent award (award Grade) for a given person, for National award
247: CURSOR C_national_award_grade IS
248: SELECT pea.segment2
249: FROM per_analysis_criteria pea,
250: per_person_analyses ppa
251: WHERE ppa.person_id = p_person_id
252: AND pea.id_flex_num = l_id_flex_num
253: AND pea.analysis_criteria_id = ppa.analysis_criteria_id
254: AND pea.segment1 = p_award_type

Line 261: per_person_analyses ppa

257: -- Selects the most recent award (award level) for a given person, for Ministry award
258: CURSOR C_ministry_award_level IS
259: SELECT pea.segment4
260: FROM per_analysis_criteria pea,
261: per_person_analyses ppa
262: WHERE ppa.person_id = p_person_id
263: AND pea.id_flex_num = l_id_flex_num
264: AND pea.segment1 = p_award_type
265: AND pea.analysis_criteria_id = ppa.analysis_criteria_id