VIEW: APPS.PAY_KR_SEP_MASTER_ASST_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)