APPS.PER_GRADES_PKG dependencies on PER_VALID_GRADES

Line 457: FROM per_valid_grades

453: WHERE grade_id = p_grd_id;
454: --
455: cursor c2 is
456: select 'x'
457: FROM per_valid_grades
458: WHERE grade_id = p_grd_id;
459: --
460: cursor c3 is
461: select 'x'

Line 612: FROM per_valid_grades vg

608: INTO l_exists
609: FROM sys.dual
610: WHERE EXISTS
611: (select 'x'
612: FROM per_valid_grades vg
613: WHERE vg.business_group_id = p_bgroup
614: AND vg.grade_id = p_grd_id);
615: EXCEPTION
616: WHEN NO_DATA_FOUND THEN null;

Line 630: DELETE FROM per_valid_grades vg

626: p_date_to_old IN DATE) IS
627:
628: BEGIN
629:
630: DELETE FROM per_valid_grades vg
631: WHERE vg.business_group_id + 0 = p_bgroup
632: AND vg.grade_id = p_grd_id
633: AND vg.date_from > p_date_to;
634: --

Line 637: UPDATE per_valid_grades vg

633: AND vg.date_from > p_date_to;
634: --
635: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions) Date tracked position req.
636: --
637: UPDATE per_valid_grades vg
638: SET vg.date_to = (select least(
639: nvl(p.date_end,p_eot),
640: nvl(j.date_to,p_eot),
641: nvl(p_date_to,p_eot))

Line 644: per_valid_grades v

640: nvl(j.date_to,p_eot),
641: nvl(p_date_to,p_eot))
642: from hr_positions p,
643: per_jobs_v j,
644: per_valid_grades v
645: where v.valid_grade_id = vg.valid_grade_id
646: and v.position_id = p.position_id(+)
647: and v.job_id = j.job_id(+)
648: )

Line 654: UPDATE per_valid_grades vg

650: AND vg.grade_id = p_grd_id
651: AND (NVL(vg.date_to,p_eot) > p_date_to
652: OR vg.date_to = p_date_to_old);
653:
654: UPDATE per_valid_grades vg
655: SET vg.date_to = null
656: WHERE vg.date_to = p_eot
657: AND vg.grade_id = p_grd_id;
658:

Line 714: FROM per_valid_grades

710: l_exists VARCHAR2(1);
711:
712: cursor c11 is
713: SELECT 'x'
714: FROM per_valid_grades
715: WHERE grade_id = p_grd_id
716: AND p_date_from > date_from;
717: --
718: begin