APPS.PER_MX_SSAFFL_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE
Line 952: from per_periods_of_service ppos,
948: cursor c_get_pos_leaving_reason(cp_assignment_id in number
949: ,cp_effective_date in date )
950: is
951: select pds_information1, actual_termination_date 952: from per_periods_of_service ppos, 953: per_all_assignments_f paf
954: where paf.assignment_id = cp_assignment_id
955: and paf.person_id = ppos.person_id
956: and cp_effective_date between paf.effective_start_date and paf.effective_end_date