DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_CANCELLED_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 666: per_periods_of_service pds

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

Line 727: per_periods_of_service pds

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