[Home] [Help]
View: HR_ASSIGNMENT_SETS_V
Product: | PER - Human Resources |
Description: | Used to support user interface |
Implementation/DBA Data: |
APPS.HR_ASSIGNMENT_SETS_V
|
View Text
SELECT ASG.ROWID ROW_ID
, ASG.ASSIGNMENT_SET_ID
, ASG.BUSINESS_GROUP_ID
, ASG.PAYROLL_ID
, ASG.ASSIGNMENT_SET_NAME
, ASG.FORMULA_ID
, ASG.LAST_UPDATE_DATE
, ASG.LAST_UPDATED_BY
, ASG.LAST_UPDATE_LOGIN
, ASG.CREATED_BY
, ASG.CREATION_DATE
, PA.PAYROLL_NAME
FROM FND_SESSIONS F
, PAY_PAYROLLS PA
, HR_ASSIGNMENT_SETS ASG
WHERE ASG.PAYROLL_ID = PA.PAYROLL_ID
AND F.SESSION_ID = USERENV('SESSIONID')
AND F.EFFECTIVE_DATE BETWEEN NVL(PA.EFFECTIVE_START_DATE
, F.EFFECTIVE_DATE)
AND NVL(PA.EFFECTIVE_END_DATE
, F.EFFECTIVE_DATE) UNION ALL SELECT ASG.ROWID ROW_ID
, ASG.ASSIGNMENT_SET_ID
, ASG.BUSINESS_GROUP_ID
, ASG.PAYROLL_ID
, ASG.ASSIGNMENT_SET_NAME
, ASG.FORMULA_ID
, ASG.LAST_UPDATE_DATE
, ASG.LAST_UPDATED_BY
, ASG.LAST_UPDATE_LOGIN
, ASG.CREATED_BY
, ASG.CREATION_DATE
, NULL
FROM HR_ASSIGNMENT_SETS ASG
WHERE ASG.PAYROLL_ID IS NULL
Columns
Name |
ROW_ID |
ASSIGNMENT_SET_ID |
BUSINESS_GROUP_ID |
PAYROLL_ID |
ASSIGNMENT_SET_NAME |
FORMULA_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
PAYROLL_NAME |