11248: WHERE organization_id = l_org_id AND group_name = l_group_name;
11249:
11250: CURSOR validate_lookup_code(l_lookup_code IN NUMBER)
11251: IS 11252: SELECT lookup_code FROM gem_lookups 11253: WHERE lookup_type = 'GME_BATCH_GROUP_ACTION'
11254: AND lookup_code = l_lookup_code
11255: AND lookup_code NOT IN (1,2);
11256: