[Home] [Help]
View: HR_H2PI_PAYROLLS_V
Product: | PER - Human Resources |
Description: | Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for payrolls |
Implementation/DBA Data: |
APPS.HR_H2PI_PAYROLLS_V
|
View Text
SELECT PAY.LAST_UPDATE_DATE
, PAY.BUSINESS_GROUP_ID
, PAY.PAYROLL_ID
, PAY.PAYROLL_NAME
, PAY.FIRST_PERIOD_END_DATE
, PAY.NUMBER_OF_YEARS
, PAY.PERIOD_TYPE
, PAY.EFFECTIVE_START_DATE
, PAY.EFFECTIVE_END_DATE
FROM PAY_ALL_PAYROLLS_F PAY
WHERE PAY.ATTRIBUTE2 = 'Y'
Columns
Name |
LAST_UPD_DATE |
BUSINESS_GROUP_ID |
PAYROLL_ID |
PAYROLL_NAME |
FIRST_PERIOD_END_DATE |
NUMBER_OF_YEARS |
PERIOD_TYPE |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |