DBA Data[Home] [Help]

APPS.PAY_PAYACVEA_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 138: from per_periods_of_service pos,

134: from per_time_periods ptp1
135: where ptp1.end_date =
136: (
137: select max(ptp2.end_date)
138: from per_periods_of_service pos,
139: per_time_periods ptp2
140: where p_session_date between
141: pos.date_start and pos.actual_termination_date
142: and pos.person_id = p_person_id