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_ANALYSIS_CRITERIA

Line 138: FROM per_analysis_criteria pea,

134: l_id_flex_num NUMBER(15);
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

Line 147: FROM per_analysis_criteria pea,

143: AND pea.analysis_criteria_id = ppa.analysis_criteria_id;
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

Line 160: FROM per_analysis_criteria pea,

156:
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

Line 171: FROM per_analysis_criteria pea,

167:
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

Line 227: FROM per_analysis_criteria pea,

223: l_id_flex_num NUMBER(15);
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

Line 236: FROM per_analysis_criteria pea,

232: AND pea.analysis_criteria_id = ppa.analysis_criteria_id;
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

Line 249: FROM per_analysis_criteria pea,

245:
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

Line 260: FROM per_analysis_criteria pea,

256:
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