DBA Data[Home] [Help]

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