Product: | PA - Projects |
---|---|
Description: | View based on pa_pay_external_payroll,per_business_groups that returns specific external payroll information for a Business Group |
Implementation/DBA Data: | APPS.PA_PAY_EXTERNAL_PAYROLL_V |
SELECT PPEP.ROWID ROW_ID
, PBG.NAME BUSINESS_GROUP
, PPEP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PPEP.PAYROLL_ID PAYROLL_ID
, PPEP.PAYROLL_NAME PAYROLL_NAME
, PPEP.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PPEP.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PPEP.PAYROLL_PROVIDER_NAME PAYROLL_PROVIDER_NAME
, PPEP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PPEP.LAST_UPDATED_BY LAST_UPDATED_BY
, PPEP.CREATION_DATE CREATION_DATE
, PPEP.CREATED_BY CREATED_BY
, PPEP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PPEP.ACTIVE_FLAG ACTIVE_FLAG
, PPEP.PRIORITY PRIORITY
, PPEP.DESCRIPTION DESCRIPTION
FROM PA_PAY_EXTERNAL_PAYROLL PPEP
, PER_BUSINESS_GROUPS PBG
WHERE PPEP.BUSINESS_GROUP_ID = PBG.BUSINESS_GROUP_ID