DBA Data[Home] [Help]

APPS.PAY_FR_ARC_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 1458: from per_periods_of_service svc

1454: ,nvl(svc.adjusted_svc_date, svc.date_start)
1455: ,hr_general.decode_lookup('LEAV_REAS', svc.leaving_reason)
1456: ,svc.pds_information11 final_pay_schedule
1457: ,fnd_date.canonical_to_date(svc.pds_information10) LWD
1458: from per_periods_of_service svc
1459: ,per_all_assignments_f asg
1460: where asg.period_of_service_id = svc.period_of_service_id
1461: and p_effective_date between asg.effective_start_date and asg.effective_end_date
1462: and asg.assignment_id = p_assignment_id;