DBA Data[Home] [Help]

VIEW: APPS.HR_H2PI_PATCH_STATUS_V

Source

View Text - Preformatted

SELECT ps.patch_number, ps.patch_name, ps.status, ps.applied_date from pay_patch_status ps WHERE ps.legislation_code = 'US' and ps.patch_name like 'GEOCODE%'
View Text - HTML Formatted

SELECT PS.PATCH_NUMBER
, PS.PATCH_NAME
, PS.STATUS
, PS.APPLIED_DATE
FROM PAY_PATCH_STATUS PS
WHERE PS.LEGISLATION_CODE = 'US'
AND PS.PATCH_NAME LIKE 'GEOCODE%'