APPS.PQH_GSP_SYNC_COMPENSATION_OBJ dependencies on PER_SPINAL_POINT_STEPS_F

Line 525: From Ben_Opt_F opt, Per_Spinal_POint_Steps_F Step

521:
522: Cursor Opt Is
523: Select opt.Opt_id , opt.Effective_Start_Date,
524: opt.Effective_End_Date,step.sequence ordr_num
525: From Ben_Opt_F opt, Per_Spinal_POint_Steps_F Step
526: Where Opt.MAPPING_TABLE_NAME = 'PER_SPINAL_POINTS'
527: and Opt.MAPPING_TABLE_PK_ID = p_spinal_point_id
528: and p_effective_date
529: between Opt.Effective_Start_Date and Opt.Effective_End_Date