[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