DBA Data[Home] [Help]

APPS.PAY_CA_EOY_T4A_CANCEL_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 668: per_periods_of_service pds

664: paf.effective_end_date
665: from pay_payroll_actions ppa,
666: pay_assignment_actions paa,
667: per_assignments_f paf,
668: per_periods_of_service pds
669: where paf.person_id = to_char(cp_person_id)
670: and paf.assignment_id = paa.assignment_id
671: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
672: and ppa.business_group_id = ln_business_group_id

Line 725: per_periods_of_service pds

721: paf.effective_end_date
722: from pay_payroll_actions ppa,
723: pay_assignment_actions paa,
724: per_assignments_f paf,
725: per_periods_of_service pds
726: where paf.person_id = to_char(cp_person_id)
727: and paf.assignment_id = paa.assignment_id
728: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
729: and ppa.business_group_id = ln_business_group_id