DBA Data[Home] [Help]

APPS.PAY_CFT_INS dependencies on PER_ASSIGNMENTS_F

Line 712: from per_assignments_f asg

708: l_effective_date date;
709: --
710: cursor c1(asg_id number) is
711: select max(effective_start_date)
712: from per_assignments_f asg
713: where asg.assignment_id = asg_id;
714:
715: Begin
716: hr_utility.set_location('Entering:'||l_proc, 5);

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

726: if c1%notfound then
727: --
728: close c1;
729: --
730: -- raise error as assignment_id not found in per_assignments_f
731: -- table.
732: --
733: --dbms_output.put_line('in assignment_id 6');
734: hr_utility.set_message(800, 'HR_74025_INVALID_ASSIGNMENT_ID');