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 555: select valid_grade_id, object_version_number from per_valid_grades

551: --
552: l_proc varchar2(72) ;
553: --
554: cursor vgr is
555: select valid_grade_id, object_version_number from per_valid_grades
556: where position_id = p_rec.position_id;
557: Begin
558: if g_debug then
559: l_proc := g_package||'pre_delete';

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

578: end if;
579: end if;
580: */
581: --
582: -- Delete from per_valid_grades rows corresponding to the position being deleted.
583: --
584: if (p_datetrack_mode = 'ZAP') then
585: for each_rec in vgr loop
586: per_vgr_del.del(p_valid_grade_id => each_rec.valid_grade_id,