DBA Data[Home] [Help]

APPS.GHR_SF113_A dependencies on PER_POSITION_DEFINITIONS

Line 111: FROM PER_POSITION_DEFINITIONS

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

Line 370: PER_POSITION_DEFINITIONS ppd,

366: pp.permanent_temporary_flag
367: FROM GHR_SF113_V v,
368: GHR_DUTY_STATIONS_F hds,
369: HR_LOCATION_EXTRA_INFO hlei,
370: PER_POSITION_DEFINITIONS ppd,
371: HR_ALL_POSITIONS_F pp,
372: PER_GRADES pg,
373: PER_GRADE_DEFINITIONS pgd
374: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1

Line 1144: PER_POSITION_DEFINITIONS ppd,

1140: FROM per_assignments_f pa,
1141: per_assignment_status_types past,
1142: GHR_PAYROLL gp,
1143: HR_ALL_POSITIONS_F pp,
1144: PER_POSITION_DEFINITIONS ppd,
1145: GHR_DUTY_STATIONS_F hds,
1146: HR_LOCATION_EXTRA_INFO hlei,
1147: PER_GRADES pg,
1148: PER_GRADE_DEFINITIONS pgd

Line 1442: PER_POSITION_DEFINITIONS ppd,

1438: FROM GHR_SF113_V v,
1439: GHR_PA_REQUESTS gpr,
1440: GHR_NATURE_OF_ACTIONS gnoa,
1441: HR_ALL_POSITIONS_F pp,
1442: PER_POSITION_DEFINITIONS ppd,
1443: GHR_DUTY_STATIONS_F hds
1444:
1445: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1
1446: ,'SEGMENT2',ppd.segment2

Line 1525: PER_POSITION_DEFINITIONS ppd,

1521: FROM GHR_SF113_V v,
1522: GHR_PA_REQUESTS gpr,
1523: GHR_NATURE_OF_ACTIONS gnoa,
1524: HR_ALL_POSITIONS_F pp,
1525: PER_POSITION_DEFINITIONS ppd,
1526: GHR_DUTY_STATIONS_F hds
1527:
1528: WHERE DECODE(p_segment,'SEGMENT1',ppd.segment1
1529: ,'SEGMENT2',ppd.segment2