APPS.HR_ASSIGNMENT dependencies on PER_SPINAL_POINT_STEPS_F

Line 2963: FROM PER_SPINAL_POINT_STEPS_F S

2959: OR (p_mode = 'FUTURE'
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)))));

Line 3090: per_spinal_point_steps_f sps

3086: --
3087: select min(psp.sequence)
3088: into l_sequence
3089: from per_spinal_points psp,
3090: per_spinal_point_steps_f sps
3091: where psp.parent_spine_id = l_parent_spine_id
3092: and psp.spinal_point_id = sps.spinal_point_id
3093: and P_edate between sps.effective_start_date
3094: and sps.effective_end_date;

Line 3102: from per_spinal_point_steps_f sps,

3098: -- Get the step id for the min sequence
3099: --
3100: select sps.step_id
3101: into l_min_step_id
3102: from per_spinal_point_steps_f sps,
3103: per_spinal_points psp
3104: where sps.spinal_point_id = psp.spinal_point_id
3105: and psp.parent_spine_id = l_parent_spine_id
3106: and psp.sequence = l_sequence;

Line 3229: FROM PER_SPINAL_POINT_STEPS_F S

3225: WHERE P.ASSIGNMENT_ID = p_assignment_id
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));

Line 5264: PER_SPINAL_POINT_STEPS_F PSPS ,

5260: PAY_ALL_PAYROLLS_F PAY ,
5261: HR_LOCATIONS_ALL_TL LOCTL ,
5262: HR_LOCATIONS_NO_JOIN LOC ,
5263: PER_ALL_PEOPLE_F SUP ,
5264: PER_SPINAL_POINT_STEPS_F PSPS ,
5265: PER_SPINAL_POINTS PSP ,
5266: HR_ALL_ORGANIZATION_UNITS O ,
5267: HR_ALL_ORGANIZATION_UNITS_TL OTL ,
5268: HR_COMMENTS COM ,