DBA Data[Home] [Help]

APPS.PAY_NO_EERR_CONTINUOUS dependencies on PER_PERIODS_OF_SERVICE

Line 389: from per_periods_of_service

385: and paaf.effective_end_date
386: and p_end_date between papf.effective_start_date
387: and papf.effective_end_date
388: and not exists (select actual_termination_date
389: from per_periods_of_service
390: where actual_termination_date =
391: paaf.effective_end_date
392: and person_id = papf.person_id
393: and actual_termination_date = nvl(final_process_date,actual_termination_date )

Line 422: from per_periods_of_service

418: --and past.PER_SYSTEM_STATUS = 'TERM_ASSIGN'
419: and (( papf.effective_end_date <= p_end_date
420: --and paaf.effective_end_date between p_start_date and p_end_date
421: and exists (select actual_termination_date
422: from per_periods_of_service
423: where actual_termination_date =
424: paaf.effective_end_date
425: and person_id = papf.person_id
426: and actual_termination_date = nvl(final_process_date,actual_termination_date )))