DBA Data[Home] [Help]

APPS.GHR_SS_VIEWS_PKG dependencies on PER_ANALYSIS_CRITERIA

Line 214: from per_analysis_criteria pea,

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

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