DBA Data[Home] [Help]

VIEW: APPS.PAY_CA_PMED_WCB_ID_V

Source

View Text - Preformatted

SELECT RATE_ID,'WCB',BUSINESS_GROUP_ID FROM PAY_WCI_RATES UNION ALL SELECT SOURCE_ID,'PMED',BUSINESS_GROUP_ID FROM PAY_CA_PMED_ACCOUNTS
View Text - HTML Formatted

SELECT RATE_ID
, 'WCB'
, BUSINESS_GROUP_ID
FROM PAY_WCI_RATES UNION ALL SELECT SOURCE_ID
, 'PMED'
, BUSINESS_GROUP_ID
FROM PAY_CA_PMED_ACCOUNTS