APPS.PER_APR_BUS dependencies on PER_PERIODS_OF_PLACEMENT

Line 103: FROM per_periods_of_placement ppser

99: WHERE person_id = ppser.person_id)
100: AND NVL (ppser.actual_termination_date, TRUNC (SYSDATE)) > TRUNC (SYSDATE)
101: UNION
102: SELECT NULL
103: FROM per_periods_of_placement ppser
104: WHERE person_id = p_appraisee_person_id
105: AND ppser.date_start = (SELECT MAX (date_start)
106: FROM per_periods_of_placement
107: WHERE person_id = ppser.person_id)

Line 106: FROM per_periods_of_placement

102: SELECT NULL
103: FROM per_periods_of_placement ppser
104: WHERE person_id = p_appraisee_person_id
105: AND ppser.date_start = (SELECT MAX (date_start)
106: FROM per_periods_of_placement
107: WHERE person_id = ppser.person_id)
108: AND NVL (ppser.actual_termination_date, TRUNC (SYSDATE)) > TRUNC (SYSDATE));
109:
110: CURSOR csr_template_info