eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ASSIGNMENT dependencies on PER_GRADE_SPINES_F

Line 3001: , PER_GRADE_SPINES_F GS

2997: AND P.EFFECTIVE_START_DATE >= p_end_date
2998: AND NOT EXISTS
2999: (SELECT NULL
3000: FROM PER_SPINAL_POINT_STEPS_F S
3001: , PER_GRADE_SPINES_F GS
3002: WHERE GS.GRADE_SPINE_ID = S.GRADE_SPINE_ID
3003: AND S.STEP_ID = P.STEP_ID
3004: AND GS.GRADE_ID = NVL(p_grade_id,-1)))));
3005: --

Line 3114: from per_grade_spines_f pgs

3110: -- get the parent spine_id for the new grade
3111: --
3112: select pgs.parent_spine_id
3113: into l_parent_spine_id
3114: from per_grade_spines_f pgs
3115: where pgs.grade_id = p_grade_id
3116: and P_edate between pgs.effective_start_date
3117: and pgs.effective_end_date;
3118:

Line 3267: , PER_GRADE_SPINES_F GS

3263: AND P.EFFECTIVE_START_DATE >= p_end_date
3264: AND NOT EXISTS
3265: (SELECT NULL
3266: FROM PER_SPINAL_POINT_STEPS_F S
3267: , PER_GRADE_SPINES_F GS
3268: WHERE GS.GRADE_SPINE_ID = S.GRADE_SPINE_ID
3269: AND S.STEP_ID = P.STEP_ID
3270: AND GS.GRADE_ID = NVL(p_grade_id,-1));
3271: */