APPS.IRC_CMC_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 335: -- 1) that object_id exists in PER_ALL_ASSIGNMENTS_F

331: -- {Start Of Comments}
332: --
333: -- Description:
334: -- This procedure is used to ensure -
335: -- 1) that object_id exists in PER_ALL_ASSIGNMENTS_F
336: -- when the object_type is 'APPL'
337: -- 2) that combination of (object_id,object_type) is
338: -- unique.
339: --

Line 365: from per_all_assignments_f paaf

361: l_object_type varchar2(1);
362: --
363: cursor csr_object_id is
364: select null
365: from per_all_assignments_f paaf
366: where paaf.assignment_id = p_object_id
367: and assignment_type = 'A';
368: --
369: cursor csr_object_type is

Line 391: -- Check that object_id exists in per_all_assignments_f

387: ,p_argument => 'OBJECT_TYPE'
388: ,p_argument_value => p_object_type
389: );
390:
391: -- Check that object_id exists in per_all_assignments_f
392: hr_utility.set_location(l_proc,20);
393: open csr_object_id;
394: fetch csr_object_id into l_object_id;
395: hr_utility.set_location(l_proc,30);