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 2964: , PER_GRADE_SPINES_F GS

2960: AND P.EFFECTIVE_START_DATE >= p_end_date
2961: AND NOT EXISTS
2962: (SELECT NULL
2963: FROM PER_SPINAL_POINT_STEPS_F S
2964: , PER_GRADE_SPINES_F GS
2965: WHERE GS.GRADE_SPINE_ID = S.GRADE_SPINE_ID
2966: AND S.STEP_ID = P.STEP_ID
2967: AND GS.GRADE_ID = NVL(p_grade_id,-1)))));
2968: --

Line 3077: from per_grade_spines_f pgs

3073: -- get the parent spine_id for the new grade
3074: --
3075: select pgs.parent_spine_id
3076: into l_parent_spine_id
3077: from per_grade_spines_f pgs
3078: where pgs.grade_id = p_grade_id
3079: and P_edate between pgs.effective_start_date
3080: and pgs.effective_end_date;
3081:

Line 3230: , PER_GRADE_SPINES_F GS

3226: AND P.EFFECTIVE_START_DATE >= p_end_date
3227: AND NOT EXISTS
3228: (SELECT NULL
3229: FROM PER_SPINAL_POINT_STEPS_F S
3230: , PER_GRADE_SPINES_F GS
3231: WHERE GS.GRADE_SPINE_ID = S.GRADE_SPINE_ID
3232: AND S.STEP_ID = P.STEP_ID
3233: AND GS.GRADE_ID = NVL(p_grade_id,-1));
3234: */