APPS.PAY_CFT_BUS dependencies on PER_ASSIGNMENTS_F

Line 167: l_business_group_id per_assignments_f.business_group_id%TYPE;

163: --
164: l_proc varchar2(72) := g_package||'chk_assignment_id';
165: l_dummy varchar2(1);
166: l_api_updating boolean;
167: l_business_group_id per_assignments_f.business_group_id%TYPE;
168: l_location_id per_assignments_f.location_id%TYPE;
169: l_country varchar2(30);
170: --
171: cursor c1 is

Line 168: l_location_id per_assignments_f.location_id%TYPE;

164: l_proc varchar2(72) := g_package||'chk_assignment_id';
165: l_dummy varchar2(1);
166: l_api_updating boolean;
167: l_business_group_id per_assignments_f.business_group_id%TYPE;
168: l_location_id per_assignments_f.location_id%TYPE;
169: l_country varchar2(30);
170: --
171: cursor c1 is
172: select business_group_id,location_id

Line 173: from per_assignments_f asg

169: l_country varchar2(30);
170: --
171: cursor c1 is
172: select business_group_id,location_id
173: from per_assignments_f asg
174: where asg.assignment_id = p_assignment_id
175: and p_effective_date between asg.effective_start_date
176: and asg.effective_end_date;
177: --

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

230: if c1%notfound then
231: --
232: close c1;
233: --
234: -- raise error as assignment_id not found in per_assignments_f
235: -- table.
236: --
237: --dbms_output.put_line('in assignment_id 6');
238: hr_utility.set_message(800, 'HR_74025_INVALID_ASSIGNMENT_ID');