DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on PER_SPINAL_POINTS

Line 3126: from per_spinal_points psp,

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

Line 3140: per_spinal_points psp

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

Line 5309: PER_SPINAL_POINTS PSP ,

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