DBA Data[Home] [Help]

APPS.PAY_CA_EOY_T4_AMEND_REG dependencies on PER_PERIODS_OF_SERVICE

Line 759: per_periods_of_service PDS

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

Line 803: per_periods_of_service PDS

799: paf.effective_end_date
800: from pay_payroll_actions ppa,
801: pay_assignment_actions paa,
802: per_assignments_f paf,
803: per_periods_of_service PDS
804: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
805: and paa.assignment_id = paf.assignment_id
806: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
807: and ppa.business_group_id = ln_business_group_id