APPS.PER_ASG_INS dependencies on DUAL

Line 485: Cursor C_Sel1 is select per_assignments_s.nextval from sys.dual;

481: l_proc varchar2(72) := g_package||'pre_insert';
482: l_exists varchar2(1);
483: l_benefits varchar2(1);
484: --
485: Cursor C_Sel1 is select per_assignments_s.nextval from sys.dual;
486: --
487: Cursor C_Sel2 is
488: Select null
489: from per_all_assignments_f

Line 672: -- restricting on individual assignments.

668: );
669:
670: --
671: -- Add this assignment to the security list when
672: -- restricting on individual assignments.
673: --
674: IF p_rec.assignment_type <> 'B' THEN
675: hr_security.add_assignment
676: (p_person_id => p_rec.person_id