DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_AMEND_REG dependencies on PER_PERIODS_OF_SERVICE

Line 728: per_periods_of_service pds

724: paf.effective_end_date
725: from pay_payroll_actions ppa,
726: pay_assignment_actions paa,
727: per_assignments_f paf,
728: per_periods_of_service pds
729: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
730: and paa.assignment_id = paf.assignment_id
731: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
732: ppa.legislative_parameters) =

Line 781: per_periods_of_service pds

777: paf.effective_end_date
778: from pay_payroll_actions ppa,
779: pay_assignment_actions paa,
780: per_assignments_f paf,
781: per_periods_of_service pds
782: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
783: and paa.assignment_id = paf.assignment_id
784: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
785: ppa.legislative_parameters) =