VIEW: APPS.PA_PAY_PAYROLLS_F_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'