DBA Data[Home] [Help]

APPS.PER_PER_BUS dependencies on PER_ASSIGNMENTS_F

Line 816: from per_assignments_f asg

812: l_system_person_type varchar2(20); --2273304
813: --
814: cursor csr_asg is
815: select null
816: from per_assignments_f asg
817: where asg.person_id = p_person_id
818: and asg.effective_start_date <= p_validation_end_date
819: and asg.effective_end_date >= p_validation_start_date
820: and asg.payroll_id is not null;