DBA Data[Home] [Help]

APPS.GHR_SF113_A dependencies on GHR_SF113_V

Line 367: FROM GHR_SF113_V v,

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

Line 1438: FROM GHR_SF113_V v,

1434: SUBSTR(hds.state_or_country_code, 1, 2) state_or_country_code,
1435: hds.msa_code,
1436: gpr.effective_date
1437:
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,

Line 1521: FROM GHR_SF113_V v,

1517: SUBSTR(hds.state_or_country_code, 1, 2) state_or_country_code,
1518: hds.msa_code,
1519: gpr.effective_date
1520:
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,