DBA Data[Home] [Help]

APPS.PQH_FR_UTILITY dependencies on PER_SPINAL_POINT_STEPS_F

Line 977: FROM per_spinal_point_steps_f sps,

973: Cursor csr_step_dtls(p_assignment_id IN NUMBER, p_effective_date IN DATE) IS
974: SELECT psp.information1 "SCALE_TYPE",
975: ssp.information1 "GROSS_INDEX",
976: ssp.information2 "SALARY_RATE"
977: FROM per_spinal_point_steps_f sps,
978: per_parent_spines psp,
979: per_spinal_points ssp
980: WHERE sps.step_id = p_step_id
981: AND p_effective_date BETWEEN sps.effective_start_date AND sps.effective_end_date