APPS.HR_PSF_DEL dependencies on PER_VALID_GRADES

Line 319: FROM PER_VALID_GRADES VG1

315: select '1'
316: into l_exists
317: from sys.dual
318: where exists(SELECT NULL
319: FROM PER_VALID_GRADES VG1
320: WHERE business_group_id + 0 = p_business_group_id
321: AND VG1.POSITION_ID = p_position_id);
322: exception when no_data_found then
323: null;

Line 546: select valid_grade_id, object_version_number from per_valid_grades

542: --
543: l_proc varchar2(72) ;
544: --
545: cursor vgr is
546: select valid_grade_id, object_version_number from per_valid_grades
547: where position_id = p_rec.position_id;
548: Begin
549: if g_debug then
550: l_proc := g_package||'pre_delete';

Line 573: -- Delete from per_valid_grades rows corresponding to the position being deleted.

569: end if;
570: end if;
571: */
572: --
573: -- Delete from per_valid_grades rows corresponding to the position being deleted.
574: --
575: if (p_datetrack_mode = 'ZAP') then
576: for each_rec in vgr loop
577: per_vgr_del.del(p_valid_grade_id => each_rec.valid_grade_id,