DBA Data[Home] [Help]

APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on PER_PERIODS_OF_SERVICE

Line 363: from per_periods_of_service

359: and paaf.effective_end_date
360: and p_end_date between papf.effective_start_date
361: and papf.effective_end_date
362: and not exists (select actual_termination_date
363: from per_periods_of_service
364: where actual_termination_date =
365: paaf.effective_end_date
366: and person_id = papf.person_id
367: and actual_termination_date = nvl(final_process_date,actual_termination_date )

Line 400: from per_periods_of_service

396: and ( ( papf.effective_end_date between p_start_date
397: and p_end_date
398: --and paaf.effective_end_date between p_start_date and p_end_date
399: and exists (select actual_termination_date
400: from per_periods_of_service
401: where actual_termination_date =
402: paaf.effective_end_date
403: and person_id = papf.person_id
404: and actual_termination_date = nvl(final_process_date,actual_termination_date ))