DBA Data[Home] [Help]

APPS.PAY_EMP_ACTION_ARCH dependencies on PER_SPINAL_POINT_STEPS_F

Line 2760: per_spinal_point_steps_f psps,

2756: cp_effective_date in date) is
2757: select count(*)
2758: from per_spinal_points psp,
2759: per_spinal_points psp2,
2760: per_spinal_point_steps_f psps,
2761: per_spinal_point_steps_f psps2
2762: where psps.step_id = cp_sp_ceil_step_id
2763: and psp.spinal_point_id = psps.spinal_point_id
2764: and psps.grade_spine_id = psps2.grade_spine_id

Line 2761: per_spinal_point_steps_f psps2

2757: select count(*)
2758: from per_spinal_points psp,
2759: per_spinal_points psp2,
2760: per_spinal_point_steps_f psps,
2761: per_spinal_point_steps_f psps2
2762: where psps.step_id = cp_sp_ceil_step_id
2763: and psp.spinal_point_id = psps.spinal_point_id
2764: and psps.grade_spine_id = psps2.grade_spine_id
2765: and psp2.spinal_point_id = psps2.spinal_point_id