DBA Data[Home] [Help]

APPS.PAY_CA_EOY_T4A_AMEND_REG dependencies on PER_PERIODS_OF_SERVICE

Line 719: per_periods_of_service pds

715: paf.effective_end_date
716: from pay_payroll_actions ppa,
717: pay_assignment_actions paa,
718: per_assignments_f paf,
719: per_periods_of_service pds
720: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
721: and paa.assignment_id = paf.assignment_id
722: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
723: and ppa.business_group_id = ln_business_group_id

Line 762: per_periods_of_service pds

758: paf.effective_end_date
759: from pay_payroll_actions ppa,
760: pay_assignment_actions paa,
761: per_assignments_f paf,
762: per_periods_of_service pds
763: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
764: and paa.assignment_id = paf.assignment_id
765: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
766: and ppa.business_group_id = ln_business_group_id