DBA Data[Home] [Help]

APPS.GHR_SF113_A dependencies on GHR_SF113_V

Line 366: FROM GHR_SF113_V v,

362: hds.msa_code,
363: pp.date_effective,
364: pp.date_end ,
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,

Line 1428: FROM GHR_SF113_V v,

1424: SUBSTR(hds.state_or_country_code, 1, 2) state_or_country_code,
1425: hds.msa_code,
1426: gpr.effective_date
1427:
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,

Line 1511: FROM GHR_SF113_V v,

1507: SUBSTR(hds.state_or_country_code, 1, 2) state_or_country_code,
1508: hds.msa_code,
1509: gpr.effective_date
1510:
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,