APPS.HR_ASSIGNMENT dependencies on PER_SPINAL_POINT_STEPS_F

Line 3000: FROM PER_SPINAL_POINT_STEPS_F S

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

Line 3127: per_spinal_point_steps_f sps

3123: --
3124: select min(psp.sequence)
3125: into l_sequence
3126: from per_spinal_points psp,
3127: per_spinal_point_steps_f sps
3128: where psp.parent_spine_id = l_parent_spine_id
3129: and psp.spinal_point_id = sps.spinal_point_id
3130: and P_edate between sps.effective_start_date
3131: and sps.effective_end_date;

Line 3139: from per_spinal_point_steps_f sps,

3135: -- Get the step id for the min sequence
3136: --
3137: select sps.step_id
3138: into l_min_step_id
3139: from per_spinal_point_steps_f sps,
3140: per_spinal_points psp
3141: where sps.spinal_point_id = psp.spinal_point_id
3142: and psp.parent_spine_id = l_parent_spine_id
3143: and psp.sequence = l_sequence;

Line 3266: FROM PER_SPINAL_POINT_STEPS_F S

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

Line 5308: PER_SPINAL_POINT_STEPS_F PSPS ,

5304: PAY_ALL_PAYROLLS_F PAY ,
5305: HR_LOCATIONS_ALL_TL LOCTL ,
5306: HR_LOCATIONS_NO_JOIN LOC ,
5307: PER_ALL_PEOPLE_F SUP ,
5308: PER_SPINAL_POINT_STEPS_F PSPS ,
5309: PER_SPINAL_POINTS PSP ,
5310: HR_ALL_ORGANIZATION_UNITS O ,
5311: HR_ALL_ORGANIZATION_UNITS_TL OTL ,
5312: HR_COMMENTS COM ,