DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL2_CANCEL_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 658: per_periods_of_service pds

654: paf.effective_end_date
655: from pay_payroll_actions ppa,
656: pay_assignment_actions paa,
657: per_assignments_f paf,
658: per_periods_of_service pds
659: where paf.person_id = to_char(cp_person_id)
660: and paf.assignment_id = paa.assignment_id
661: and paf.effective_start_date <= cp_effective_date
662: and paf.effective_end_date >= trunc(cp_effective_date,'Y')

Line 716: per_periods_of_service pds

712: paf.effective_end_date
713: from pay_payroll_actions ppa,
714: pay_assignment_actions paa,
715: per_assignments_f paf,
716: per_periods_of_service pds
717: where paf.person_id = to_char(cp_person_id)
718: and paf.assignment_id = paa.assignment_id
719: and paf.effective_start_date <= cp_effective_date
720: and paf.effective_end_date >= trunc(cp_effective_date,'Y')