APPS.GHR_SS_VIEWS_PKG dependencies on PER_ANALYSIS_CRITERIA

Line 239: from per_analysis_criteria pea,

235: -- if duplicate Start Dates, go with the greatest ID
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

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 667: FROM per_analysis_criteria pea,

663: nvl(pea.end_date_active, nvl(pan.date_from, sysdate)) AND
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