View: PA_PAY_PAYROLLS_F_V

Product:	PA - Projects
Description:	PA_PAY_COSTED_SET_LOV_V stores the details of internal and third party payroll
Implementation/DBA Data:	APPS.PA_PAY_PAYROLLS_F_V

View Text

SELECT 'INTERNAL'
, PAYROLL_NAME
, PAYROLL_ID
, BUSINESS_GROUP_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
FROM PAY_PAYROLLS_F UNION SELECT 'EXTERNAL'
, PAYROLL_NAME
, PAYROLL_ID
, BUSINESS_GROUP_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
FROM PA_PAY_EXTERNAL_PAYROLL
WHERE NVL(ACTIVE_FLAG
, 'N') ='Y'

Columns