APPS.PAY_CPT_INS dependencies on PER_ASSIGNMENTS_F

Line 737: from per_assignments_f asg

733: l_proc varchar2(72) := g_package||'ins';
734: l_effective_date date;
735: cursor c1(asg_id number) is
736: select max(effective_start_date)
737: from per_assignments_f asg
738: where asg.assignment_id = asg_id;
739: --
740: Begin
741: hr_utility.set_location('Entering:'||l_proc, 5);

Line 753: -- raise error as assignment_id not found in per_assignments_f

749: if c1%notfound then
750: --
751: close c1;
752: --
753: -- raise error as assignment_id not found in per_assignments_f
754: -- table.
755: --
756: --dbms_output.put_line('in assignment_id 6');
757: hr_utility.set_message(800, 'HR_74025_INVALID_ASSIGNMENT_ID');