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_SS_VIEWS_PKG dependencies on PER_PERSON_ANALYSES

Line 240: per_person_analyses pan

236:
237: cursor get_latest_perf_rating is
238: select pan.person_analysis_id, pea.segment2 rating_of_record
239: from per_analysis_criteria pea,
240: per_person_analyses pan
241: where pan.person_id = p_person_id and
242: pan.id_flex_num = g_perf_flex_num and
243: pea.id_flex_num = pan.id_flex_num and
244: nvl(pan.date_from,sysdate) between nvl(pea.start_date_active,nvl(pan.date_from,sysdate) )

Line 248: from per_person_analyses pan

244: nvl(pan.date_from,sysdate) between nvl(pea.start_date_active,nvl(pan.date_from,sysdate) )
245: and nvl(pea.end_date_active,nvl(pan.date_from,sysdate) ) and
246: pan.analysis_criteria_id = pea.analysis_criteria_id and
247: trunc(nvl(pan.date_from,sysdate)) = (select max(trunc(nvl(pan.date_from,sysdate))) max_date_from
248: from per_person_analyses pan
249: where pan.person_id = p_person_id and
250: pan.id_flex_num = g_perf_flex_num and
251: trunc(nvl(pan.date_from,sysdate)) <= p_effective_date )
252:

Line 657: FROM per_analysis_criteria pea, per_person_analyses pan

653: -- cursor get_rating_of_record gets the rating of record.
654:
655: CURSOR get_rating_of_record IS
656: SELECT pan.person_analysis_id, pea.segment5 rating_of_record
657: FROM per_analysis_criteria pea, per_person_analyses pan
658: WHERE pan.person_id = p_person_id and
659: pan.id_flex_num = g_perf_flex_num AND
660: pea.id_flex_num = pan.id_flex_num AND
661: nvl(pan.date_from, sysdate) BETWEEN

Line 668: per_person_analyses pan

664: pan.analysis_criteria_id = pea.analysis_criteria_id AND
665: trunc(nvl(to_date(pea.segment3,'yyyy/mm/dd hh24:mi:ss'),nvl(pan.date_from, sysdate)))
666: = (SELECT max(trunc(nvl( to_date(pea.segment3,'yyyy/mm/dd hh24:mi:ss'),nvl(pan.date_from, sysdate)))) max_eff_date
667: FROM per_analysis_criteria pea,
668: per_person_analyses pan
669: WHERE pan.person_id = p_person_id AND
670: pan.id_flex_num = g_perf_flex_num AND
671: pea.id_flex_num = pan.id_flex_num AND
672: pan.analysis_criteria_id = pea.analysis_criteria_id AND