APPS.JA_CN_HRMS_EXPORT_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 490: per_periods_of_service pos

486: to_char(pos.actual_termination_date,
487: 'YYYYMMDD') TERMINATION_DATE
488: FROM per_people_f ppf,
489: per_assignments_f paf,
490: per_periods_of_service pos
491: WHERE ppf.business_group_id = paf.business_group_id
492: AND pos.period_of_service_id = paf.period_of_service_id
493: AND paf.person_id = ppf.person_id
494: AND (pd_acc_end_date BETWEEN paf.effective_start_date AND

Line 512: FROM per_periods_of_service ppos

508: ppf.effective_end_date)
509: --bug# 10066598, employment temination and rehire
510: AND pos.period_of_service_id =
511: ( SELECT MAX(ppos.period_of_service_id)
512: FROM per_periods_of_service ppos
513: WHERE ppos.person_id = ppf.person_id)
514: )
515: AND ppf.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
516: AND paf.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');