DBA Data[Home] [Help]

APPS.PAY_CA_EOY_T4_CANCEL_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 707: per_periods_of_service PDS

703: paf.effective_end_date
704: from pay_payroll_actions ppa,
705: pay_assignment_actions paa,
706: per_assignments_f paf,
707: per_periods_of_service PDS
708: where paf.person_id = to_char(cp_person_id)
709: and paf.assignment_id = paa.assignment_id
710: and paa.tax_unit_id = nvl(cp_tax_unit_id,paa.tax_unit_id)
711: and ppa.business_group_id = ln_business_group_id

Line 764: per_periods_of_service PDS

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