APPS.PQH_FR_ASSIGNMENT_CHK dependencies on PQH_FR_STAT_SITUATIONS_V

Line 288: pqh_fr_stat_situations_v ss

284:
285: Cursor csr_situation_info IS
286: select ss.situation_type
287: from pqh_fr_emp_stat_situations ess,
288: pqh_fr_stat_situations_v ss
289: where person_id = p_person_id
290: and p_effective_date between actual_start_date and nvl(actual_end_date,provisional_end_date)
291: and ess.statutory_situation_id = ss.statutory_situation_id;
292: --