DBA Data[Home] [Help]

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 813: -- restricting on individual assignments.

809: -- End changes for bug 13855370
810:
811: --
812: -- Add this assignment to the security list when
813: -- restricting on individual assignments.
814: --
815: IF p_rec.assignment_type <> 'B' THEN
816: hr_security.add_assignment
817: (p_person_id => p_rec.person_id