APPS.PSP_ENC_ASSIGNMENT_CHANGES dependencies on PER_PERIODS_OF_SERVICE
Line 483: FROM PER_PERIODS_OF_SERVICE
479:
480: BEGIN
481:
482: SELECT actual_termination_date into p_actual_date 483: FROM PER_PERIODS_OF_SERVICE 484: WHERE person_id =p_new_person_id --- replaced for 3184075 to resolve ORA-4091
485: /* (SELECT paf.person_id
486: FROM per_assignments_f paf
487: WHERE paf.assignment_id = p_new_assignment_id) -- Introduced for bug fix 3263333 */