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