[Home] [Help]
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
Name |
DESCRIPTION |
PAYROLL_NAME |
PAYROLL_ID |
BUSINESS_GROUP_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |