APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on PER_ANALYSIS_CRITERIA

Line 1590: per_analysis_criteria pac

1586: pac.segment5 faculty,
1587: pac.segment6 faculty_kana,
1588: pac.segment7 department
1589: from per_person_analyses ppa,
1590: per_analysis_criteria pac
1591: where ppa.person_id = l_person_id
1592: and nvl(ppa.date_from,l_effective_date_ass) <= l_effective_date_ass
1593: and ppa.id_flex_num = c_jp_pea_flex_num
1594: and pac.analysis_criteria_id = ppa.analysis_criteria_id