367: GHR_DUTY_STATIONS_F hds,
368: HR_LOCATION_EXTRA_INFO hlei,
369: PER_POSITION_DEFINITIONS ppd,
370: HR_ALL_POSITIONS_F pp,
371: PER_GRADES pg,
372: PER_GRADE_DEFINITIONS pgd
373: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1
374: ,'SEGMENT2',ppd.segment2
375: ,'SEGMENT3',ppd.segment3
1133: HR_ALL_POSITIONS_F pp,
1134: PER_POSITION_DEFINITIONS ppd,
1135: GHR_DUTY_STATIONS_F hds,
1136: HR_LOCATION_EXTRA_INFO hlei,
1137: PER_GRADES pg,
1138: PER_GRADE_DEFINITIONS pgd
1139: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1
1140: ,'SEGMENT2',ppd.segment2
1141: ,'SEGMENT3',ppd.segment3