[Home] [Help]
754: c_business_group_id NUMBER,
755: c_payroll_id NUMBER) IS
756:
757: SELECT 'Y'
758: FROM hr_assignment_sets aset
759: WHERE aset.assignment_set_name = c_assignmentset_name
760: and nvl(aset.payroll_id,c_payroll_id) = c_payroll_id
761: and aset.business_group_id = c_business_group_id
762: and (not exists