DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on PER_SPINAL_POINTS

Line 3089: from per_spinal_points psp,

3085: -- Get the min seuence for the new grade
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

Line 3103: per_spinal_points psp

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;
3107:

Line 5265: PER_SPINAL_POINTS PSP ,

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 ,
5269: GL_SETS_OF_BOOKS GL ,