DBA Data[Home] [Help]

APPS.PAY_CFT_INS dependencies on PER_ASSIGNMENTS_F

Line 704: from per_assignments_f asg

700: l_effective_date date;
701: --
702: cursor c1(asg_id number) is
703: select max(effective_start_date)
704: from per_assignments_f asg
705: where asg.assignment_id = asg_id;
706:
707: Begin
708: hr_utility.set_location('Entering:'||l_proc, 5);

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

718: if c1%notfound then
719: --
720: close c1;
721: --
722: -- raise error as assignment_id not found in per_assignments_f
723: -- table.
724: --
725: --dbms_output.put_line('in assignment_id 6');
726: hr_utility.set_message(800, 'HR_74025_INVALID_ASSIGNMENT_ID');