APPS.GHR_SS_VIEWS_PKG dependencies on PER_PERSON_ANALYSES

Line 215: per_person_analyses pan

211:
212: cursor get_latest_perf_rating is
213: select pan.person_analysis_id, pea.segment2 rating_of_record
214: from per_analysis_criteria pea,
215: per_person_analyses pan
216: where pan.person_id = p_person_id and
217: pan.id_flex_num = g_perf_flex_num and
218: pea.id_flex_num = pan.id_flex_num and
219: nvl(pan.date_from,sysdate) between nvl(pea.start_date_active,nvl(pan.date_from,sysdate) )

Line 223: from per_person_analyses pan

219: nvl(pan.date_from,sysdate) between nvl(pea.start_date_active,nvl(pan.date_from,sysdate) )
220: and nvl(pea.end_date_active,nvl(pan.date_from,sysdate) ) and
221: pan.analysis_criteria_id = pea.analysis_criteria_id and
222: trunc(nvl(pan.date_from,sysdate)) = (select max(trunc(nvl(pan.date_from,sysdate))) max_date_from
223: from per_person_analyses pan
224: where pan.person_id = p_person_id and
225: pan.id_flex_num = g_perf_flex_num and
226: trunc(nvl(pan.date_from,sysdate)) <= p_effective_date )
227:

Line 632: from per_analysis_criteria pea, per_person_analyses pan

628: -- cursor get_rating_of_record gets the rating of record.
629:
630: cursor get_rating_of_record is
631: select pan.person_analysis_id, pea.segment5 rating_of_record
632: from per_analysis_criteria pea, per_person_analyses pan
633: where pan.person_id = p_person_id and
634: pan.id_flex_num = g_perf_flex_num and
635: pea.id_flex_num = pan.id_flex_num and
636: nvl(pan.date_from, sysdate) between