VIEW: APPS.HR_ASSIGNMENT_SETS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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