APPS.PQH_GSP_SYNC_COMPENSATION_OBJ dependencies on PER_PARENT_SPINES

Line 518: from per_spinal_points psp, per_parent_spines pps

514: and p_effective_date between Effective_Start_Date and Effective_End_Date;
515:
516: cursor point is
517: select psp.spinal_point_id spinal_point_id,psp.spinal_point spinal_point,pps.name scale_name
518: from per_spinal_points psp, per_parent_spines pps
519: where psp.spinal_point_id = p_spinal_point_id
520: and psp.parent_spine_id = pps.parent_spine_id;
521:
522: Cursor Opt Is