DBA Data[Home] [Help]

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 */