DBA Data[Home] [Help]

APPS.PER_ASSIGNMENTS_V8_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 948: from per_periods_of_service p

944: --
945: cursor get_per_start_date
946: is
947: select p.date_start
948: from per_periods_of_service p
949: where p.person_id = p_person_id
950: and p.period_of_service_id = p_period_of_service_id;
951: --
952: cursor get_termination_date

Line 955: from per_periods_of_service pos

951: --
952: cursor get_termination_date
953: is
954: select pos.actual_termination_date
955: from per_periods_of_service pos
956: where pos.person_id = p_person_id
957: and pos.period_of_service_id = p_period_of_service_id;
958: --
959: p_termination_date DATE;