DBA Data[Home] [Help]

APPS.GHR_SF113_A dependencies on PER_POSITION_DEFINITIONS

Line 110: FROM PER_POSITION_DEFINITIONS

106: 'SEGMENT27',SEGMENT27,
107: 'SEGMENT28',SEGMENT28,
108: 'SEGMENT29',SEGMENT29,
109: 'SEGMENT30',SEGMENT30) AGCY
110: FROM PER_POSITION_DEFINITIONS
111: WHERE DECODE(p_segment,'SEGMENT1',segment1
112: ,'SEGMENT2',segment2
113: ,'SEGMENT3',segment3
114: ,'SEGMENT4',segment4

Line 369: PER_POSITION_DEFINITIONS ppd,

365: pp.permanent_temporary_flag
366: FROM GHR_SF113_V v,
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

Line 1134: PER_POSITION_DEFINITIONS ppd,

1130: FROM per_assignments_f pa,
1131: per_assignment_status_types past,
1132: GHR_PAYROLL gp,
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

Line 1432: PER_POSITION_DEFINITIONS ppd,

1428: FROM GHR_SF113_V v,
1429: GHR_PA_REQUESTS gpr,
1430: GHR_NATURE_OF_ACTIONS gnoa,
1431: HR_ALL_POSITIONS_F pp,
1432: PER_POSITION_DEFINITIONS ppd,
1433: GHR_DUTY_STATIONS_F hds
1434:
1435: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1
1436: ,'SEGMENT2',ppd.segment2

Line 1515: PER_POSITION_DEFINITIONS ppd,

1511: FROM GHR_SF113_V v,
1512: GHR_PA_REQUESTS gpr,
1513: GHR_NATURE_OF_ACTIONS gnoa,
1514: HR_ALL_POSITIONS_F pp,
1515: PER_POSITION_DEFINITIONS ppd,
1516: GHR_DUTY_STATIONS_F hds
1517:
1518: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1
1519: ,'SEGMENT2',ppd.segment2