eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_GSP_BEN_VALIDATIONS dependencies on PER_SPINAL_POINTS

Line 374: From per_spinal_points point,

370:
371: Cursor csr_step_id
372: IS
373: Select Step.step_id
374: From per_spinal_points point,
375: per_parent_spines Scale,
376: per_grade_spines_f spine,
377: per_spinal_point_steps_f step
378: Where point.SPINAL_POINT_ID = p_spinal_point_Id

Line 450: and opt.MAPPING_TABLE_NAME= 'PER_SPINAL_POINTS'

446: And oipl.OIPL_STAT_CD = 'A'
447: And oipl.Pl_id = pl.PL_ID
448: And oipl.Business_Group_Id= p_business_group_id
449: And oipl.opt_id = opt.opt_id
450: and opt.MAPPING_TABLE_NAME= 'PER_SPINAL_POINTS'
451: And pl.MAPPING_TABLE_NAME = 'PER_GRADES'
452: AND p_effective_date BETWEEN oipl.EFFECTIVE_START_DATE
453: And nvl(oipl.Effective_End_Date, hr_general.end_of_time)
454: AND p_effective_date BETWEEN PL.EFFECTIVE_START_DATE