View: PAY_KR_SEP_MASTER_ASST_V

Product:	PAY - Payroll
Description:	This view returns Separation Pay Process Assignment Set based on business_group_id.
Implementation/DBA Data:	APPS.PAY_KR_SEP_MASTER_ASST_V

View Text

SELECT HAS.ROWID ROW_ID
, HAS.ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID
, HAS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, HAS.ASSIGNMENT_SET_NAME ASSIGNMENT_SET_NAME
, HAS.PAYROLL_ID PAYROLL_ID
FROM HR_ASSIGNMENT_SETS HAS
WHERE HAS.FORMULA_ID IS NULL
AND NOT EXISTS( SELECT NULL
FROM HR_ASSIGNMENT_SET_CRITERIA HASC
WHERE HASC.ASSIGNMENT_SET_ID = HAS.ASSIGNMENT_SET_ID)

Columns